Posted by John Kane on 08/02/05 04:39

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

[Back to original message]