Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
Functions, 86 of 121
SOUNDEX
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:
b, f, p, v = 1 c, g, j, k, q, s, x, z = 2 d, t = 3 l = 4 m, n = 5 r = 6
SELECT ename FROM emp WHERE SOUNDEX(ename) = SOUNDEX('SMYTHE'); ENAME ---------- SMITH
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|