Indexing (and searching for) percentages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

positron - 28 Apr 2008 16:56 GMT

Hi,

I have got the following text in a column that is part of a full-text
index (SQL Server 2005):

Lorem 7% ipsum

I understand that by default both the number 7 and the % character are
ignored, the former being a noise word, the latter being a special
character.

While it should be pretty simple to remove the single numbers from the
noise words list, I wonder if there is a way to overcome the problem
with the percent symbol.

Any help will be appreciated.

Thanks,
Paolo

Reply to this Message

Hilary Cotter - 28 Apr 2008 17:08 GMT

What most people do is to convert the symbol % to the word percent. Then
they trap searches on % to expand it to percent. So a search on 90% would
become a search on 90 percent.

Note that with the numbers removed from the noise word list and your catalog
rebuilt a search on something like 7% will return hits to rows containing
7%, 7!, 7@, 7$, in 7 followed by a non-indexable character.

> Hi,
>
[quoted text clipped - 15 lines]
> Thanks,
> Paolo

Reply to this Message