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???
See response in .datawarehouse. -- ======== Michael Coles "Pro SQL Server 2008 XML" http://www.amazon.com/Pro-SQL-Server-2008-XML/dp/1590599837/ "Travis McGee" wrote in message news:OtJ$wZY2IHA.4920@TK2MSFTNGP05.phx.gbl... > 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??? >
