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. |
Examples
• B?ll
finds ball, bell, and bill
• wh*
finds what, white, and why
Related Topics:
 How to create a view
About SQL Query Builder
SQL Query Builder Layout
Add or remove a table
Add a column
Customize the table
and view names
Customize the column names
Using criteria
to retrieve certain records
Expression Builder
Comparison operators
Logical operators
Mathematical operators
Show or hide
a column in a view's results
Group Rows in query results
Results Pane
| 
