"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

"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...
> >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
>
>