>I am making a small pseudo-search engine for my VFP data. I am trying to figure out how to do a search for multiple words with % rating. So if you do a search for 'steve craft' and in a column I have
>
> steve croft
> steve cake
> ed gaugler
> joe snyder
> steve craft
> stu baker
>
>You will get a result set like
>
>steve craft - 100% confidence
>steve croft - 90% confidence
>steve cake - 50% confidence
>stu baker - 2% confidence
>
>?
>
>Thanks.
You might look at SOUNDEX(). It might not be exactly what you want, but you could probably use it as a base for your own "rating" algorithm.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up
