Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 111 of 166
soundex::=
soundex
SOUNDEX
returns a character string containing the phonetic representation of char
. This function lets you 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
char
can be of any of the datatypes CHAR
, VARCHAR2
, NCHAR
, or NVARCHAR2
. The return value is the same datatype as char.
Note:
This function does not support |
The following example returns the employees whose last names are a phonetic representation of "Smyth":
SELECT last_name, first_name FROM hr.employees WHERE SOUNDEX(last_name) = SOUNDEX('SMYTHE'); LAST_NAME FIRST_NAME ---------- ---------- Smith Lindsey Smith William
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|