EchoAlertcom
IS-IT--Management
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
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