How do I do a query looking for a literal "?" in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to do a query where one of the things I am looking for is "?".
However, when I run this:

like "*NYD*" or like "*?*"or "nyd*" or like "Not yet diagnosed" or like
"NOT YET
DIAGNOSED*" or like "No diagnosis" or like "*suspected*" or like
"*Probable*" or like "*Diagnosis uncertain*" or like "*Unknown*" or like
"*UNKOWN*" or like "*Undiagnosed*" or like “(*?*)†I get a range of
additional entries. It has been suggested that ? is the opposite of null. How
do I therefore literalise "?" ?
 
If you want to search for "wildcard" characters literally, surround them
with [ ] characters:

like "*[?]*"
 
Back
Top