aamer
Aug 5th, 1999, 11:02 AM
What is the alternative to Soundex function (which is in Oracle)in MS ACCESS.
Can u help me???
bashfirst
Aug 5th, 1999, 04:55 PM
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