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
Can you do a FreeText query?
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
"Brian Kitt" <BrianKitt@.discussions.microsoft.com> wrote in message
news:49595D7D-4338-4C5A-BF5A-73C34740FE64@.microsoft.com...
>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
|||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?
"Hilary Cotter" wrote:
> Can you do a FreeText query?
> --
> 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
> "Brian Kitt" <BrianKitt@.discussions.microsoft.com> wrote in message
> news:49595D7D-4338-4C5A-BF5A-73C34740FE64@.microsoft.com...
>
>
|||FreeText is an OR. Contains will be a strict phrase based search unless you
make it Boolean.
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
"Brian Kitt" <BrianKitt@.discussions.microsoft.com> wrote in message
news:8FFCB088-055B-4DFF-99C6-B9E123936523@.microsoft.com...[vbcol=seagreen]
>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?
> "Hilary Cotter" wrote:
没有评论:
发表评论