Stay informed about any major changes. Click here to subscribe
Using wildcard characters
You can search for patterns within data columns or expressions by using
wildcard characters. For example, you can search for all customers whose
last names begin with "S".
To search for patterns, use the LIKE operator, and then substitute wildcard
characters for one or more characters in the search string. You can use
either of the following wildcard characters:
Wildcard character
Description
* (asterisk)
Matches any number of characters in Microsoft Access.
It can be used as the first or last character in the character string.
% (percent symbol)
Matches any number of characters in Microsoft SQL
Server. It can be used as the first or last character in the character
string.
_ (underscore)
Matches any single alphabetic character in Microsoft
SQL Server.
? (question mark)
Matches any single alphabetic character in Microsoft
Access.
