Re: soundex ?
From: J.P. <jp_boileau_at_yahoo.com>
Date: 15 Apr 2002 06:27:30 -0700
Message-ID: <7e388bc3.0204150527.7d2cfd38_at_posting.google.com>
S530
S532
Date: 15 Apr 2002 06:27:30 -0700
Message-ID: <7e388bc3.0204150527.7d2cfd38_at_posting.google.com>
Soundex is a simple oracle function. You just use it around the column_name you want. e.g.:
1* select soundex('Smith') from dual
SQL> /
SOUN
S530
SQL> ed
Wrote file afiedt.buf
1* select soundex('Smithsonian') from dual SQL> / SOUN
S532
JP
"Des" <dlimss_at_yahoo.com.sg> wrote in message news:<a9aovb$379$1_at_newton.pacific.net.sg>...
> Hi !
>
> How is the above being used ?
>
> TIA !
Received on Mon Apr 15 2002 - 15:27:30 CEST