What Is the Wildcard in Access

Wildcards are special characters that can stand in for unknown characters in a text value and are handy for locating multiple items with similar, but not identical data. … Access supports two sets of wildcard characters because it supports two standards for Structured Query Language

What is an example of a wildcard search?

The wildcard is an advanced search technique that can be used to maximize your search results in library databases. … For example: searching for educat* would tell the database to look for all possible endings to that root. Results will include educate, educated, education, educational or educator.

What does asterisk mean in access?

The asterisk “*” and the question mark “?” are the two main wildcard characters in Access you need to know. The asterisk represents multiple unknown characters. For example, the criteria “N*” would find all “N” words like “Nebraska,” “Ned,” “Not,” “Never Ever,” etc. The question mark represents one unknown character.