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