LIKE contains %

Question

I have record in table like 'abc 100% text'.

I want to search all the records that contain 100%.

What will be LIKE query?

SELECT * FROM TABLE where ColName LIKE '100%%'

above query returns wrong results.

Thanks.

Answer 1

SELECT * FROM TABLE where ColName LIKE '%100[%]%'

Have a look at Using Wildcard Characters As Literals

You can use the wildcard pattern matching characters as literal characters. To use a wildcard character as a literal character, enclose the wildcard character in brackets.