D
Dawn_P_28Access
Guest
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?
Graham T
Registered User.
- Local time
- Today, 12:43
- Joined
- Mar 14, 2001
- Messages
- 300
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
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
Similar threads
Solved
Left or Mid?
