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.