same results regardless of operator usage

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DC Gringo - 12 Aug 2005 21:26 GMT

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

Reply to this Message

Hilary Cotter - 13 Aug 2005 00:43 GMT

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

Signature

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

> I am getting the same number of records resulting from this search,
> regardless of the use of the operators "AND" and "OR"
[quoted text clipped - 18 lines]
> _____
> DC G

Reply to this Message