views:

27

answers:

0

Hi guys

I have a problem with a FTS on SQL Server 2008.

First I am not an expert in that field.

The problem is as following. I have a row with column value 'This is it aka Michael Jacksons's This is it'.

When user enters in a search box term "This is it" following query returns 0 results.

SELECT column_list FROM tabla_name WHERE
CONTAINS(columan_name,'("This is it") OR (This NEAR is NEAR it)')

Also stopwords/noise words are disabled.

Also I know I can use a LIKE clause but that table is large so its slow and expensive.

Any suggestions how to fix this.