>I found a switch at the table level, where there seems to be additional properties not available under the Storage tree. There is a switch to use or not the stoplist. When disabled, the index becomes bloated. So, we cannot use that. I will see about allowing specific words, which means, moving them out of the stoplist table. But, for now, I would suggest, when going for an exact match, to avoid the "the" in front and use the rest such as "report writer".
>
>Because, basically, using "the report writer" and "report writer", as search criteria, returns the same amount of records because the word "the" is omitted from the search.
If you want to search for exact phrase, use LIKE operator. Obviously the query is not going to be optimized unless you have some other criteria that can use an index
... LIKE '%' + < Exact Phrase > + '%'
--sb--