Returns a phonetic representation of the specified character expression.
- Specifies the character expression SOUNDEX(В ) evaluates.
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.
CLEAR ? SOUNDEX('Smith') = SOUNDEX('Smyth') && Displays .T. ? SOUNDEX('Computer') && Displays C513