4.9.2.75 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;