LIKE

This comparison operator uses wildcards to compare two strings. The wildcards have the following meaning:

%	Any number of characters (including 0)
?	Any single character (which must be present)
*	Any number of characters (including 0)(Access only)

NOTE: You must use single quotes to delimit the wildcard string.

Examples:

field

fred

bread

release

field LIKE '%re%' returns "fred", "bread", and "release"

field LIKE '?re%' returns "fred", and "bread"

field LIKE '?re?' returns "fred"