Thanks Sergey,
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.