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???