Noise Words SQL SERVER 2005 BackSlash

Question

Hi,

How do I make SQL SERVER 2005 to ignore the backslash in the following search:

select [description] from MyTable where contains([description], '3/4 and bear')

It is blowing off on "/"!

Answer 1

Try this

select [description] from MyTable
where [description] LIKE '%3/4 and bear%'

Answer 2

try using '"3/4 and bear'"