I'm hoping someone can comment on the issue I'm having with full text search when it encounters a noise word.
For example, assume we have a Publication name of "Something at Somewhere".
The following query will return no results:
select * from Publications WHERE CONTAINS((PublicationName),'"Something " AND "at" AND "Somewhere"')
Whereas the below query will return the correct results:
select * from Publications WHERE CONTAINS((PublicationName),'"Something" AND "Somewhere"')
If the terms are "" qualified or not makes no difference either.
This behaviour seems to be the case when any noise word is encountered (not just "at" as in the above example). BOL states that when a noise word is encountered, it is excluded from the query but something els
View Complete Post