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:

• retain the first letter of the string and remove the following letters: a, e, h, i, o, w, y
• assign the numbers to the remaining letters as follows: 0 = a, e, h, i, o, w, y 1 = b, f, p, v 2 = c, e, g, j, k, q, s, x, z 3 = d, t = 3 4 = l 5 = m, n r = 6
• if two or more of the numbers are in sequences, remove all but the first
• return the first four bytes padded with 0

Example

SELECT ename
 FROM emp
 WHERE SOUNDEX(ename)

• SOUNDEX('SMYTHE')

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