I am trying to filter items with a stored procedure using like. The column is a varchar(15). The items I am trying to filter have square brackets in the name.

For example: WC[R]S123456.

If I do a LIKE 'WC[R]S123456' it will not return anything.

I found some information on using the ESCAPE keyword with LIKE but I do not understand how to use it to treat the square brackets as a regular string.

+5  A:

LIKE 'WC[[R]S123456'


LIKE 'WC\[R]S123456'

Should work.

Otávio Décio
I just found this website right before you answered.

Here is what I actually used:

like 'WC![R]S123456' ESCAPE '!'

+1  A: 

The ESCAPE keyword is used if you need to search for special characters like % and _, which are normally wild cards. If you specify ESCAPE, SQL will search literally for the characters % and _.

Here's a good article with some more examples

+3  A: 

I needed to exclude names that started with an underscore from a query, so I ended up with this:

WHERE b.[name] not like '\_%' escape '\'  -- use \ as the escape character
Andrew Backer

Can anybody explian is there a speacial meaning for LIKE '%[0001%'. When I filter based on '%[0001%' sql server is not finding any records. But, if I search by '%0001]%' sql server is finding right results.

@sss Ask this as a question in it's own right not as an answer to someone elses!
Martin Smith
But a quick test says you need Escape. e.g. `SELECT A FROM (SELECT 'TE[0001]TE' AS A) T WHERE A LIKE '%\[0001%' ESCAPE '\'`
Martin Smith