Using NEAR -- sql server full text search

John Kane
5/19/2004 7:36:13 AM

Dario,
Are you looking for info on how to "influence" the NEAR function or want to
know how NEAR determines how *near* the words are to each other? Could you
provide some examples SQL FTS queries using NEAR and what your interested in
achieving?

Regards,
John

[quoted text, click to view]

Dario
5/20/2004 1:34:49 AM

Basically we are switching the full text engine from
DTSearch to SQL FTS. In DTSearch there were an option to
tell the engine how many words before and after to look
for with the *NEAR* clause.
On SQL FTS the number of words before and after the first
one are much higher and the users are complaining about
it.

Regards
Dario

[quoted text, click to view]

John Kane
5/20/2004 7:27:56 AM

Dario,
Unfortunately, SQL FTS is not as flexible as dtSearch in regards to how near
one word is to another. Basically, "near" is hard-coded at a 50 word spread,
i.e., any word can be *near* any other word within 50 words. There are other
factors as well, such as paragraph stops (CR/LF), but in SQL Server 2000
this cannot be altered. This may or may not change in the future release of
SQL Serve 2005 (codename Yukon) that will be in public beta later this year.

Regards,
John

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server full text search

sql server full text search : Using NEAR