SoundEx Function

The SoundEx() function returns soundex code. It takes one (1) argument as text and returns code for it. The Soundex system is a method of indexing names to identify spelling variations.

The syntax for SoundEx function is SoundEx( String ).

SELECT SoundEx('SQLDatabase.Net') /* returns S243 */ ;

SELECT SOUNDEX ('Smith'), SOUNDEX ('Smythe') /* returns S530 S530 */ ;