same results regardless of operator usage

12 Aug 2005 8:26 PM

DC Gringo

I am getting the same number of records resulting from this search,
regardless of the use of the operators "AND" and "OR"

All three of these yield the same results:

declare @keywords varchar(25)
set @keywords = ' "word1 and word2" '

declare @keywords varchar(25)
set @keywords = ' "word1 or word2" '

declare @keywords varchar(25)
set @keywords = ' "word1 word2" '

....when I run this:

SELECT id
FROM table1
WHERE FREETEXT(column1,@keywords)

_____
DC G

12 Aug 2005 11:43 PM

Hilary Cotter

FreeText ignores Boolean operators, that's why you are getting the same
results.

--
Hilary Cotter
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

Show quote

"DC Gringo" <dcgri***@visiontechnology.net> wrote in message
news:%23vBCsw3nFHA.2152@TK2MSFTNGP14.phx.gbl...
> I am getting the same number of records resulting from this search,
> regardless of the use of the operators "AND" and "OR"
>
> All three of these yield the same results:
>
> declare @keywords varchar(25)
> set @keywords = ' "word1 and word2" '
>
> declare @keywords varchar(25)
> set @keywords = ' "word1 or word2" '
>
> declare @keywords varchar(25)
> set @keywords = ' "word1 word2" '
>
>
> ...when I run this:
>
> SELECT id
> FROM table1
> WHERE FREETEXT(column1,@keywords)
>
>
> _____
> DC G
>
>