SQL Query: LIKE x%

Question

I have a problem with my SQL Query and I would kindly ask for help.

I have rows like:

2% 

20%

a 20% b

a 2 b

a 2% b

etc.

I want to see only those that contain '2%' inside the string.

When I wanted to filter them using:

WHERE ColA LIKE '%2%%' 

it showed all above rows, instead of only:

2%

a 2% b

Could you help me with it?

Answer 1

Try this

WHERE ColA LIKE '%2[%]%' 

Answer 2

% matches any string in SQL, you have to escape the %. You can do this by defining an escape character in the same command:

WHERE ColA LIKE '%2/%%' ESCAPE '/';