Returns a phonetic representation of the specified character expression.
Syntax
SOUNDEX(cExpression)
Returns
Character
Arguments
cExpression
Specifies the character expression SOUNDEX( ) evaluates.
Remarks
SOUNDEX( ) returns a four-character string. By comparing the results SOUNDEX( ) returns for two character expressions, you can determine if the two expressions are phonetically similar, indicating that they sound alike. This can be useful when searching for duplicate records in a table.
SOUNDEX( ) isn't case sensitive and generally disregards vowels.