Soundex() or Difference function in VB


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Soundex() or Difference function in VB

Hybrid View

  1. #1
    Narto Guest

    Soundex() or Difference function in VB


    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


  2. #2
    Sue Harsevoort Guest

    Re: Soundex() or Difference function in VB

    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
    >




  3. #3
    Douglas J. Steele Guest

    Re: Soundex() or Difference function in VB

    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
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center