FTS for noise chars only

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi.. SQL 2K issue. My client wishes to FTS for certain noise chars
only, e.g. % which of course isn't in the noise word files. The best
I've been able to come up with to resolve this is to escape the
characters when I enter the string into CONTAINSTABLE, however the
results return as if the query was "% AND escape"

This anyway seems to be a cludge, which I'm very tempted to use as a
temporary (forever)solution but I would really appreciate it if someone
could point me to the error of my ways or tell me if this is at all
possible.

I know that the best solution would be to go through the text and
change all % chars to something that I could then search against, but
A) this isn't the only char that he's interested in and B) the data is
historic, large, formatted and extracted from a Notes DB, so I'd rather
not go there for the moment.

Appreciation in advance

Neil

.

Relevant Pages