DO free text search with SQL server returns unexpected results : a search for 1-1BL6-3006 returns way too much entities, that does not have this string in their full text indexed column. I suppose this is because '-' is interpreted as a special character.

Besides Sql profiler shows that the query executed uses FREETEXTTABLE and not CONTAINSTABLE. In my case :

SELECT *
FROM FREETEXTTABLE([dbo].[SPB.Document], *, '1-1BL6-3006') as ft
INNER JOIN [SPB.Document] d ON (ft.[KEY] = d.[Id]);

returns 154 results.

SELECT *
FROM CONTAINSTABLE([dbo].[SPB.Document], *, '1-1BL6-3006') as ft
INNER JOIN [SPB.Document] d ON (ft.[KEY] = d.[Id]);

returns 3 results. (correct)

Can you :

• Use FREETEXTABLE which was used in DO 3.X (or provide an option / alternative method to do this)
• Show me how I can replace FREETEXTTABLE by CONTAINSTABLE in generated sql. (the example does not cover this case : is this possible?)

This would also allow me to fix this question : Full text search with *