SQL Query where the wildcard is the % sign

How do I do a wildcard where the character I'm looking for is the % sign?

I tried LIKE '%%%' and that returned every row.

I need to find the % sign anywhere in the field I'm searching.
LVL 2
AlemusAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
LIKE '%[%]%'
0
 
sventhanCommented:
SELECT columns FROM table WHERE
    column LIKE '%[%]%'
 
or
 
SELECT columns FROM table WHERE
    column LIKE '%\%%' ESCAPE '\'

http://sqlserver2000.databases.aspfaq.com/how-do-i-search-for-special-characters-e-g-in-sql-server.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.