condition like '%'%' 2

[Kendel]

Hi All,

I'm trying to search for customer's name with an apostrophen how can I do that?

I'm testing it in Query analyzer and this won't work:

Select * from CustTable where customerName like '%'%'

Thanks.

 

[SQLDenis]

you have to double the tick

Select * from CustTable where customerName like '%''%'

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

 

[gmmastros]

Double the single-quote within the percents, like this...

Select * from CustTable where customerName like '%'[!]'[/!]%'

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[Kendel]

Thank you guys.