Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.

But the problem is not only that it is considered a stop word, its also a keyword to the contains function?
– Anders LindénJun 7 '13 at 14:26

Also, when looking at the database in ssms, the Full Text Stoplists node has no sub items. Does that mean there is no stoplist?
– Anders LindénJun 7 '13 at 14:27

Updated my answer. AND is not included in the index at all as being a default stopword. Edit the list of default stopwords for your language manually at specified location and rebuild index.
– StolegJun 7 '13 at 14:57

Lets assume I can get rid of all stopwords, how do I write a query that searches for "AND"?
– Anders LindénJun 7 '13 at 21:45