SOUNDEX

SOUNDEX(string)

Description

Returns a four character code representing the sound of a string. See also http://www.archives.gov/genealogy/census/soundex.html . This method returns a string.

Examples

SELECT SOUNDEX(NAME) FROM Players;