View Full Version : Searching for ? (Question Mark)


Dawn_P_28Access
03-01-2002, 01:15 PM
I am currently viewing clipper/DBase tables within Access 97 and some fields contain the character ?.

How can I search on this character in a query?

Graham T
03-04-2002, 01:24 AM
Dawn_P

The following criteria should set you on your way:

Like "*[?]*"

You will need to enclose the ? mark in square brackets as Access interprets this as a wildcard character.

You should also take a look at the Microsoft KB for an article relating to this: ACC2000: How to Search for Characters or Strings in Records
http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q209536&LN=EN-US&rnk=3&SD=tech&FR=0&qry=searching%20for%20?%20character&src=DHCS_MSPSS_tech_SRCH&SPR=ACC2000&

HTH