>We need to search the Full text index with words such as "a" "it" "is" and others. Can you help with some example FTS predicates?
>
Hi Glenn,
You cannot search for something that is not in an full-text index. The "a", "it" and "is" are considered noise word and ignored by full-text service during index creation and generate an error if used in FTS. See
http://www.databasejournal.com/features/mssql/article.php/3454281/Full-Text-Search-on-SQL-2000-Part-2.htm for more info. Check also
Full-Text Search Recommendations in BOL 2000.
--sb--