SOUNDEX(string_exp)

Returns a data source-dependent character string representing the sound of the words in string_exp. A SOUNDEX code is returned.

 

Example:

SELECT SOUNDEX('SMITH') returns S53 (the SOUNDEX code for words that sound like "Smith")