Groups | Blog | Home
all groups > sql server full text search > july 2006 >

sql server full text search : NEAR with sql2005


Hilary Cotter
7/29/2006 12:00:00 AM
No, you can't near is factored into rank. The closer the two words are
together the higher the rank all other things being equal.

--
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]

salucci
7/29/2006 1:05:23 AM
Hello, there is the chance to know "how near" one word is to another
in the following query

SELECT Description
FROM Production.ProductDescription
WHERE CONTAINS(Description, 'bike NEAR performance');

Moreover, could we control the proximity distance somewhat?
We use sql2005

Thanks
AddThis Social Bookmark Button