Re: Problem using FREETEXT

Tech-Archive recommends: Speed Up your PC by fixing your registry

Freetext does not support Boolean.
--
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<bosuch@xxxxxxxxx> wrote in message
news:1182976764.479515.63810@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I've got a .Net web page using OleDb to query my catalog. The query
string looks like this:

Select Filename, Size, Path, Create, Rank from SCOPE(" + scope + ")
where FREETEXT(Contents,'" + TextBox1.Text + "') order by Rank desc

The problem is that I can't get a boolean operator to limit the
documents returned. For example, I search using "smith AND cindy" and
get 66 documents back. The first two, with a Rank of 105, contain both
words, but the rest (with ranks below 65 or so) only contain one of
the words.

How can I limit it to only return the two matching documents?



.