Re: PHONETIC QUERY? HOW??

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Tue, 3 Aug 1999 10:25:02 -0400
Message-ID: <7o70jp$6rj$2@autumn.news.rcn.net>

Hi,

Have you looked at the Soundex function?

SQL> select soundex('silva') from dual

        SOUN
        ----
        S410

You only have to know the initial letter of the word you are encoding. Note that Soundex converts anything to a four character code consisting of the initial letter followed by three digits. It is great for grouping and for getting close to the desired value, but cannot guarantee a unique result.

regards
Jerry Gitomer (G356)

Flavio Silva wrote in message
<37a6d1f4.0_at_news.americasnet.com>...
>Hi!
>
>I need to do a phonetic query to a database. Do you guys have
any code to do
>it??
>
>Thanks a bunch!
>
>
>fsilva_at_pobox.com
>
>
>
Received on Tue Aug 03 1999 - 09:25:02 CDT