Search for asterik (*) as a character

  • Thread starter Thread starter LISA
  • Start date Start date
L

LISA

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

update query with asterisk 4
why asterik (*doc or *docx) in save types 5
Not show 1
Wild card in query 3
Flag a Field 3
How do you find and replace a Wildcard character in Excel? 8
Password Characters such as "*" 8
How can I find an asterik "*" in a spreadsheet using ctrl+F? 4

Back
Top