Full text matching and quotes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brian Kitt - 21 Dec 2005 20:56 GMT

I have data in my full text column such as "men's shoes". When a user does a
search such as "mens shoes" it does not return a match, because the user data
does not contain the quote. If they search on "men's shoes" then it works
properly.

Anybody run into this and have ideas about how to deal with this situation?
Granted it's basically a user error, but I wanted to see if anyone has ideas?
Thanks

Reply to this Message

Hilary Cotter - 21 Dec 2005 21:56 GMT

Can you do a FreeText query?

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 have data in my full text column such as "men's shoes". When a user does
>a
[quoted text clipped - 8 lines]
> ideas?
> Thanks

Reply to this Message

Brian Kitt - 22 Dec 2005 15:32 GMT

I give the user the option to do an 'AND' or an 'OR' with search terms. My
understanding of FreeText is that it is always an 'AND' and I don't have the
option for 'OR'. Is that correct?

> Can you do a FreeText query?
>
[quoted text clipped - 10 lines]
> > ideas?
> > Thanks

Reply to this Message

Hilary Cotter - 24 Dec 2005 03:48 GMT

FreeText is an OR. Contains will be a strict phrase based search unless you
make it Boolean.

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 give the user the option to do an 'AND' or an 'OR' with search terms. My
> understanding of FreeText is that it is always an 'AND' and I don't have
[quoted text clipped - 18 lines]
>> > ideas?
>> > Thanks

Reply to this Message