Search for %

J

JLong

I need to search a SQL database for a % character. I have
tried many variations of " and ' but can't make it work.
How can I search for the percent % caracter in a text
field?
 
J

John Vinson

I need to search a SQL database for a % character. I have
tried many variations of " and ' but can't make it work.
How can I search for the percent % caracter in a text
field?
Click to expand...

If it's from an Access frontend, you should be able to use square
brackets as a quote character:

LIKE "%[%]%"

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top