How to ESCAPE a single quote

[EchoAlertcom]

Hello,

I am trying to search a column in our database for a single quote ('). Since it is a varchar column and the is the delimiter it isn't letting me search for '.

Select UID, EmailAddr from dbo.users where emailaddr like '%!'%' ESCAPE '!'

Can anyone help me out please?

Sincerely,
Steve

 

[swampBoogie]

Select UID, EmailAddr 
from dbo.users 
where emailaddr like '%''%'

The escape clause is used to define an escape character for woildcards in a search pattern.

 

[cmmrfrds]

Try putting the quote in brackets.

like '%[']%'