How to make SQL SERVER 2005 ignore backslashes in the following search:
select [description] from MyTable where contains([description], '3/4 and bear')
It resets to "/"!
try using "3/4 and carry"
Try this select [description] from MyTable where [description] LIKE '% 3/4 and carry%'