Hi all,

I have tried use Soundex(0 or Difference function to match two text variable
or more in FoxPro and SQL.

For example

a= "Smith"
b= "Smyth"
c= "Smythe"

Select Soundex(a,b)
Select Difference (a, b)

I want to get the name on sinonim sound or phonetic. "Smith" as same as "Smithe",
"Smyth" or "Smit".

And than, now, I use VB and Access as database. But I don't find as like
function above(Soundex & Difference). Can everyone have tricky to handle