 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / August 2006multiple words researchs
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 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.  SignatureHilary 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 > Hi, > I have some problems when searching using contains with multiple words. [quoted text clipped - 4 lines] > Many thanks > Stephane |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.