You still can use FTS to search for words in the title just not for the noise words.
>
>I was afraid of that. We have >4million titles on file and "[title] like'%'+ rtrin(@searchstring)+'%''" can be pretty slow for a web store application. Maybe if I get a little "inventive" with indexing parts of the title string we can kick it up a little.
>
>Glenn
>
>>>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--