Search for asterik (*) as a character

L

LISA

Does anyone know how to search a query for the asterik (*)
as a character instead of it being used as a wildcard?
 
T

Tom Ellison

Dear Lisa:

If you do not have any wildcards in the search string, then simply do
not use "LIKE" for the search. All asterisks will be taken literally.

If you have both a literal asterisk and a wildcard asterisk, continue
to use LIKE, but put the literal asterisk inside square brackets: [*]

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
D

Douglas J. Steele

If the field strictly contains asterisk, = "*" will work. If you want to
check whether an asterisk appears anywhere in the field, use Like "*[*]*"
 
Top