Soundex() or Difference function in VB

[Narto]

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
it???


Rgrds,
Narto

[Sue Harsevoort]

I'm not sure if it will help you or not, but there was an article in the
June 2000 VBPJ about using Soundex in VB.

Sue

"Narto" <narto_gens@hotmail.com> wrote in message
news:3bafe42b$1@news.devx.com...
>
> 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
> it???
>
>
> Rgrds,
> Narto
>

[Douglas J. Steele]

Joe Foster used to have a Soundex routine available on his site
http://members.ricochet.net/~jfoster

However, it looks as though the server's toast right now.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele


"Narto" <narto_gens@hotmail.com> wrote in message
news:3bafe42b$1@news.devx.com...
>
> 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
> it???
>
>
> Rgrds,
> Narto
>