Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PHONETIC QUERY? HOW??

Re: PHONETIC QUERY? HOW??

From: Michel Cadot <micadot_at_altern.org>
Date: Tue, 3 Aug 1999 15:50:38 +0200
Message-ID: <7o6s4i$pv1$1@oceanite.cybercable.fr>


Do you the SOUNDEX function ?

Syntax: SOUNDEX(char)

Purpose:

Returns a character string containing the phonetic representation of char. This function allows you to compare words that are spelled differently, but sound alike in English.

The phonetic representation is defined in The Art of Computer Programming, Volume 3: Sorting and Searching, by Donald E. Knuth, as follows:

Example

SELECT ename
 FROM emp
 WHERE SOUNDEX(ename)

ENAME

SMITH Flavio Silva a écrit dans le 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 - 08:50:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US