Re: soundex
Date: Wed, 23 Aug 2000 08:49:23 -0600
Message-ID: <YARo5.29$_H3.9386_at_wdc-read-01.qwest.net>
Try this link for an explanation of soundex coding: http://www.rootscomputing.com/howto/soundex/soundex.htm
Oracle implements it as a function:
<SQL> select soundex(dummy), soundex('dwyer'), soundex('jose'), soundex('reyes'), soundex('rays') from dual
SOUN SOUN SOUN SOUN SOUN
---- ---- ---- ---- ----
X000 D600 J200 R200 R200
You can store the values and/or use them in a comparison:
<SQL> select * from dual where soundex('reyes') = soundex('rays');
D
-
X
"Jose Reyes" <jose.reyes_at_thinkinc.com> wrote in message
news:39A16F9E.49D15E28_at_thinkinc.com...
> Has anyone ever used this command in Oracle 8.1 and if so give a small
> of example of how it works. A link to a page on how to use it would be
> helpful as well.
>
> Thanks.
>
Received on Wed Aug 23 2000 - 16:49:23 CEST