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?
How can I search on this character in a query?
|
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 |