Near keyword in Full Text Search SQL Server 2005

I have a SQL Server 2005 with SP2 and when use the FTS, a could observe that
AND and NEAR opertors are returning exactly the same results.
Anyone has any ideas?
Tanks in advanced
With FreeText they do. With contains if they are near to each other they
will as well, with containstable the rank will drop off after a separation
distance of 50 words, results with a separation distance in excess of 50
words will not show up. With freetexttable after 50 words the rank will be 0
but they will show up until 1326 (IIRC) words separation - this is by
design.
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
"BrunoX" <BrunoX@.discussions.microsoft.com> wrote in message
news:87CE32E0-180E-4327-A264-D9ABFFE5D3CB@.microsoft.com...
>I have a SQL Server 2005 with SP2 and when use the FTS, a could observe
>that
> AND and NEAR opertors are returning exactly the same results.
> Anyone has any ideas?
> Tanks in advanced
|||Tanks Hilary,
Now I am using CONTAINSTABLE and analyzing the proximity by the value of rank.
"Hilary Cotter" wrote:

> With FreeText they do. With contains if they are near to each other they
> will as well, with containstable the rank will drop off after a separation
> distance of 50 words, results with a separation distance in excess of 50
> words will not show up. With freetexttable after 50 words the rank will be 0
> but they will show up until 1326 (IIRC) words separation - this is by
> design.
> --
> 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
> "BrunoX" <BrunoX@.discussions.microsoft.com> wrote in message
> news:87CE32E0-180E-4327-A264-D9ABFFE5D3CB@.microsoft.com...
>
>