Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Text Search

Author  Topic 

chillspider
Starting Member

3 Posts

Posted - 2002-03-25 : 00:20:30
anyone have any idea where or how I can get an SQL script that allow me to score the results...the score base on how many time the words appears...and closests to the phrase
It's like the SQL Server Full-Text Search...
I dont expect to be as fast or as roburst as SQL Server functions...
THanks.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-03-25 : 07:20:58
This might give you some hints:

http://www.sqlteam.com/item.asp?ItemID=5857

It's set up for SQL Server, but the technique is usable in Access. I'm pretty sure you can modify it for matching phrases as well as words.

Go to Top of Page

chillspider
Starting Member

3 Posts

Posted - 2002-03-25 : 21:03:07
Thanks.

----------------------------<br>
Happy Coding People
Go to Top of Page
   

- Advertisement -