L LISA Sep 1, 2004 #1 Does anyone know how to search a query for the asterik (*) as a character instead of it being used as a wildcard?
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 Sep 1, 2004 #2 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
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 Sep 1, 2004 #3 If the field strictly contains asterisk, = "*" will work. If you want to check whether an asterisk appears anywhere in the field, use Like "*[*]*"
If the field strictly contains asterisk, = "*" will work. If you want to check whether an asterisk appears anywhere in the field, use Like "*[*]*"
