sql server full text search: multiple words researchs -- sql server full text search

multiple words researchs

stdu
8/22/2006 4:05:16 PM

sql server full text search:

Hi,
I have some problems when searching using contains with multiple words.
A exemple: I have records with keyword bell and some othe with "bell pepper"
(including quotes)
Is it possible to sort records with the bell only keyword before the bell
peppers ?
Many thanks
Stephane

Re: multiple words researchs

Hilary Cotter
8/22/2006 7:26:11 PM

You are looking for the hitcount operator which is not supported in SQL FTS,
but is supported in other Microsoft Search Products. However if you are
using FreeText and searching on bell pepper hits on rows containing bell
will be ranked lower than rows containing bell pepper.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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

[quoted text, click to view]