Hi,

The reason why you are not getting the result is that the record which matches "day", doesnt have "5" in that record and vice-versa.

So if you try with OR instead...

Hi,

If you want to use contains then you can't use like what you did it.

where contains(@field1,'"5 AND day"') -- This is wrong, because in full text search every word should...

Hi,

I have used sql profiler also to find out the problem..

In sql profiler what i found that it was using sp_cursorprepare to supply all the parameterized values,because we are using...

Hi,

If you want use multiple words inside contains keyword then your string should be like

where contains(field1,' "firstword" or "secondword"')

So if you want to use parameterized value then you have...