Search for %

[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?

 

[Douglas J. Steele]

Try putting square brackets around the character: LIKE '%[%]%'

 

[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?

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