SOUNDEX function (ODBC compatible)
Syntax
SOUNDEX ( string_exp )
Description
The scalar function SOUNDEX returns a four-character soundex code for character strings that are composed of a contiguous sequence of valid single- or double-byte roman letters.
Example
SELECT SOUNDEX('Roberts')
FROM syscalctable;