We implemented Fulltext on our system. No customization, no added stoplist. We turned off Stoplist on the FT Index.
I have a data column that contains the following text "Point 5 CAD" defined nvarchar(255).
We dont understand if we do select * from Table where contains(column,'"Point" and "5" and "CAD"') we get no results
if we do select * from Table where contains(column,'"Point 5 CAD"') - we get rows returned
if we do select * from Table where contains(column,'"Point 5 cad"') - we get no rows returned