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

Near keyword in Full Text Search SQL server 2005

We've migrated to SQL 2005 and we are seeing that AND and NEAR opertors are
returning exactly the same results, this behavior did not occur in SQL 2000.
example:
select count(*) from table1 where contains(*,'foo near bar') = 2494
select count(*) from table1 where contains(*,'"foo" and "bar"') = 2494
I have tried all of the syntax options I could find and am also able to
provide examples where foo and bar are quite far apart (~3000 characters) far
more than 50 words I've seen quoted for 2005. Appreciate if anyone has any
ideas on why. Do I need to change some setting in the SQL Server?
ThanksI reported this as a bug to Microsoft some time ago, and I was told that
this behavior is by design due to a customer request. Here is my original
post.
http://groups.google.com/group/microsoft.public.sqlserver.fulltext/msg/252dd1d3d6fedaa0?dmode=source
--
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
"so3" <so3@.discussions.microsoft.com> wrote in message
news:31E328D2-CB77-47A1-9B19-A319DBE29320@.microsoft.com...
> We've migrated to SQL 2005 and we are seeing that AND and NEAR opertors
> are
> returning exactly the same results, this behavior did not occur in SQL
> 2000.
> example:
> select count(*) from table1 where contains(*,'foo near bar') = 2494
> select count(*) from table1 where contains(*,'"foo" and "bar"') = 2494
> I have tried all of the syntax options I could find and am also able to
> provide examples where foo and bar are quite far apart (~3000 characters)
> far
> more than 50 words I've seen quoted for 2005. Appreciate if anyone has
> any
> ideas on why. Do I need to change some setting in the SQL Server?
> Thanks