[Microsoft Access] LIKE condition, using wildcard

This MSAccess tutorial explains how to create a query using the LIKE condition with wildcards in Access 2007 (with screenshots and step-by-step instructions).

The LIKE condition allows you to use wildcards in the where clause of a SQL statement in Access 2007. This allows you to perform pattern matching. The LIKE condition can be used in any valid SQL statement - select, insert, update, or delete.
The patterns that you can choose from are:

 Here is an example of how you'd use the LIKE condition in a query:

In this example, we are looking for all employee last names that start with "m".
Combining the LIKE condition with the NOT operator

You can also combine the LIKE condition with the NOT operator.

Here is an example of how you'd use the NOT LIKE condition in a query:

In this example, we are looking for all employee last names that do not start with "m".


::source::