Results 1 to 2 of 2

Thread: Alternative to "Soundex" function in SQL in Oracle

  1. Aug 5th, 1999, 11:02 AM #1
    aamer
    aamer is offline

    Thread Starter
    Junior Member
    Join Date
    Jun 1999
    Location
    Karachi, Sind, Pakistan
    Posts
    20

    Post

    What is the alternative to Soundex function (which is in Oracle)in MS ACCESS.
    Can u help me???
    Reply With Quote Reply With Quote
  2. Aug 5th, 1999, 04:55 PM #2
    bashfirst
    bashfirst is offline
    Lively Member
    Join Date
    Jun 1999
    Location
    Raleigh, NC
    Posts
    70

    Post

    As you've already figured out, there is no Soundex function in Access... however, you could write your own Soundex function and invoke it on your database. You can visit some of the genealogy web sites for a definition of how Soundex works, it's pretty straightforward. You may want to add an extra column to your table containing the names so that you can do an update on your records, rather than trying to use the function in joins or other more strenuous queries.

    Bash
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width