noise/stop words and CONTAINSTABLE vs. FREETEXTTABLE

Tech-Archive recommends: Fix windows errors by optimizing your registry



Hi,

I have a web app which allows user to enter complex queries with
(),and,or,... If the user enters a stop/noise word liek this "termA
and noiseWord and termB" I get no result. I see no simple way to
remove the stop words from a complex query without writing a complete
parser. The only solution I found on the web was to use FREETEXTTABLE
but then the user could not enter boolean expressions. Is there a way
to let CONTAINSTABLE remove stop/noise words?

regards,
Achim

.