How to do "with all of the words" and "without the words"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

news.microsoft.com - 14 Dec 2004 21:19 GMT

like google Advanced Search in SQL full-text search?

I use :
CONTAINSTABLE(table_full_text_search,*,'"for" and "dog" ') to search the
(all of the words).but the "for" is noise word,I cannot search...
if i use FREETEXTTABLE it looks like return me OR search with "for" and
"dog"

Anybody can help me??

Reply to this Message

John Kane - 15 Dec 2004 02:33 GMT

RLiu,
Yes, I can. This is primarily a searcher's input parsing task either one
that can be done client or server side as well as via removing all (or most)
of the noise words in your language-specific noise file under
\FTDATA\SQLServer\Config\ noise.* where * is the 3 letter language (enu =
US_English, dat = Neutral). You can also wrap the entire or parts of the
searcher's input string in double quotes, i.e.. a "phrased search". See SQL
Server 2000 BOL title "Full-text Search Recommendations" as well as the
following KB article 246800 (Q246800) "INF: Correctly Parsing Quotation
Marks in FTS Queries" at
http://support.microsoft.com//default.aspx?scid=kb;EN-US;246800 that
provides both VBScript and JavaScript code. Note, if you do remove all noise
words, you should not empty the entire file, i.e.. leave a space, as there
is a bug that occurs with zero length noise word files.

Regards,
John

> like google Advanced Search in SQL full-text search?
>
[quoted text clipped - 5 lines]
>
> Anybody can help me??

Reply to this Message