Return to the SQL Tips
Soundex Function
The Soundex function is useful for finding strings for which the sound is known but the precise spelling is not. It makes assumptions about
the way that letters and combinations of letters sound that can help to search out words with similar sounds. The comparison can be done
directly or by passing the strings as arguments to the Difference function.
Example:
Using the EMPLOYEE table, find the EMPNO and LASTNAME of the employee
with a surname that sounds like 'Loucesy'.
SELECT EMPNO,LASTNAME
FROM EMPLOYEE
WHERE SOUNDEX (LASTNAME)=SOUNDEX ('Loucesy')
Returns row:
000110 LUCCHESSI
For a description of Soundex and to see a working online demonstration, go tohttp://www.geocities.com/Heartland/Hills/3916/soundex.html .
[report a broken link by clicking here]