noise/stop words and CONTAINSTABLE vs. FREETEXTTABLE
- From: Achim Domma <achim.domma@xxxxxxxx>
- Date: 7 May 2007 07:40:42 -0700
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
.
- Follow-Ups:
- Re: noise/stop words and CONTAINSTABLE vs. FREETEXTTABLE
- From: Hilary Cotter
- Re: noise/stop words and CONTAINSTABLE vs. FREETEXTTABLE
- Prev by Date: How Robust the SQL serve 2005 is...
- Next by Date: Re: noise/stop words and CONTAINSTABLE vs. FREETEXTTABLE
- Previous by thread: How Robust the SQL serve 2005 is...
- Next by thread: Re: noise/stop words and CONTAINSTABLE vs. FREETEXTTABLE
- Index(es):