The Soundex function returns a 4-character code that represents the sound of the words in the argument.

Example :

Use the Soundex function to find a row where the sound of the LASTNAME value closely matches the phonetic spelling of ‘Loucesy’:

Select Empno, Lastname

From EmployeeTable

Where Soundex(Lastname) = Soundex(‘Loucesy’);

This example returns the following row

100 LUCCHESSI