Wildcards can be used in queries when you know only part of a value, want to search for a value based on some of the letters or numbers it contains, or want to retrieve data that matches a pattern.
Simple query criteria, such as typing "owner" in the ContactTitle field, will only find data that is an exact match. If someone is an "owner/operator", the record will not be retrieved. Wildcards can extend the power of your queries beyond simple criteria.
Wildcards are symbols and characters that represent the data you are looking for. For example, a number sign (#)wildcard is used to represent any single numeric character.
When you use wildcards, you also use the Like operator. For example, Like A* would find all customers in your database whose last name starts with "A".
Note Wildcard syntax must be compatible with the database engine that you use. The syntax in the table on the left works with default Access databases, which are based on the Microsoft Jet database engine and use ANSI-89 wildcards.
However, if your database uses syntax compatible with Microsoft SQL Server™, or if you are working with an Access project (an Access file that connects to a SQL Server database), you should use ANSI-92 wildcards, which you can find in the Quick Reference Card at the end of this course.