Confidence searching

[GJParker]

Hi,
I need to code a search that uses a phrase (input by the user), possibly break it into keywords which will be used to compare to some database fields; an entry title, and an entry description (up to 700 chars). This part I should be able to handle but...

I would like the search to be able to return a confidence rating for each record returned. How can I go about this?

I think that full-text indexing is not available on the SQL server that I'm using.

Many thanks Gary Parker
Systems Support Analyst

 

[Targol]

You can use a query with "LIKE" operator and then compare the result with the words you searched for. Water is not bad as long as it stays out human body ;-)