Question about Proximity (NEARness) with Full Text Indexing on SQL Server 7

Hello group,
Does anyone know how near a word needs to be to another word to be
included in the results of a CONTAINS search that uses NEAR? Is this
setting adjustable? Is is stored in the registry? INI or config file?
I'm using SQL Server 7 SP3.
Thanks,
Kelly Greer
KellyGreer1@.nospam.com
replace nospam with yahoo
Its hardcoded. I believe after 50 words the rank drops off to 0. I also
believe that after 1366 (or some large number of words like that) you will
no longer get a hit.
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
"kellygreer1" <kellygreer1@.yahoo.com> wrote in message
news:1122912214.203288.58290@.g47g2000cwa.googlegro ups.com...
> Hello group,
> Does anyone know how near a word needs to be to another word to be
> included in the results of a CONTAINS search that uses NEAR? Is this
> setting adjustable? Is is stored in the registry? INI or config file?
> I'm using SQL Server 7 SP3.
> Thanks,
> Kelly Greer
> KellyGreer1@.nospam.com
> replace nospam with yahoo
>
|||Kelly,
Q. Does anyone know how near a word needs to be to another word to be
included in the results of a CONTAINS search that uses NEAR?
A. Within 50 non-noise words. Additionally, end-of-sentence and
end-of-paragraph also have an effect on the "nearness" of one word or phrase
to another word or phrase.
Q. Is this setting adjustable?
A. No. This is hard-coded.
Q. Is it stored in the registry? INI or config file?
A. No and No. Although, I would hope in some future SQL Server version
(post-SQL Server 2005) that this would be possible, IMHO.
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"kellygreer1" <kellygreer1@.yahoo.com> wrote in message
news:1122912214.203288.58290@.g47g2000cwa.googlegro ups.com...
> Hello group,
> Does anyone know how near a word needs to be to another word to be
> included in the results of a CONTAINS search that uses NEAR? Is this
> setting adjustable? Is is stored in the registry? INI or config file?
> I'm using SQL Server 7 SP3.
> Thanks,
> Kelly Greer
> KellyGreer1@.nospam.com
> replace nospam with yahoo
>

Question about Proximity (NEARness) with Full Text Indexing on SQL Server 7

Hello group,

Does anyone know how near a word needs to be to another word to be
included in the results of a CONTAINS search that uses NEAR? Is this
setting adjustable? Is is stored in the registry? INI or config file?

I'm using SQL Server 7 SP3.

Thanks,
Kelly Greer
KellyGreer1@.nospam.com
replace nospam with yahooIts hardcoded. I believe after 50 words the rank drops off to 0. I also
believe that after 1366 (or some large number of words like that) you will
no longer get a hit.

--
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
"kellygreer1" <kellygreer1@.yahoo.com> wrote in message
news:1122912214.203288.58290@.g47g2000cwa.googlegro ups.com...
> Hello group,
> Does anyone know how near a word needs to be to another word to be
> included in the results of a CONTAINS search that uses NEAR? Is this
> setting adjustable? Is is stored in the registry? INI or config file?
> I'm using SQL Server 7 SP3.
> Thanks,
> Kelly Greer
> KellyGreer1@.nospam.com
> replace nospam with yahoo|||Kelly,
Q. Does anyone know how near a word needs to be to another word to be
included in the results of a CONTAINS search that uses NEAR?
A. Within 50 non-noise words. Additionally, end-of-sentence and
end-of-paragraph also have an effect on the "nearness" of one word or phrase
to another word or phrase.

Q. Is this setting adjustable?
A. No. This is hard-coded.

Q. Is it stored in the registry? INI or config file?
A. No and No. Although, I would hope in some future SQL Server version
(post-SQL Server 2005) that this would be possible, IMHO.

Regards,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

"kellygreer1" <kellygreer1@.yahoo.com> wrote in message
news:1122912214.203288.58290@.g47g2000cwa.googlegro ups.com...
> Hello group,
> Does anyone know how near a word needs to be to another word to be
> included in the results of a CONTAINS search that uses NEAR? Is this
> setting adjustable? Is is stored in the registry? INI or config file?
> I'm using SQL Server 7 SP3.
> Thanks,
> Kelly Greer
> KellyGreer1@.nospam.com
> replace nospam with yahoo