LIKE search statement for a '%@%'

#11

See response in .datawarehouse.

--

========
Michael Coles
"Pro SQL Server 2008 XML"
http://www.amazon.com/Pro-SQL-Server...dp/1590599837/

"Travis McGee" <travisGatesMcGee (AT) hotmail (DOT) com> wrote

Quote:

Does anybody know why searching for a string '@' with LIKE does not work
even when you use ESCAPE

Very strange......

Say the field has ..... I love my @*&!& friend
And I want to SELECT this row when I search for @ with LIKE
Select * from myTable where myField like '%@%' does not work
Select * from myTable where myField like '%#@%' escape '#' does not
work either
Select * from myTable where myField like '%' + char(64) + '%' does not
work either

What a pain in the something search + Why me

Any help???

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

LIKE search statement for a '%@%'

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Re: LIKE search statement for a '%@%' - 06-29-2008 , 01:44 AM