NEAR with sql2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

salucci - 29 Jul 2006 09:05 GMT

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

Reply to this Message

Hilary Cotter - 29 Jul 2006 11:33 GMT

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.

Signature

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

> Hello, there is the chance to know "how near" one word is to another
> in the following query
[quoted text clipped - 7 lines]
>
> Thanks

Reply to this Message