SOUNDEX( ) Function
Returns a phonetic representation of the specified character expression.
SOUNDEX(cExpression)
Parameters
- cExpression
Specifies the character expression SOUNDEX( ) evaluates.
Return Value
Character
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.
Example
CLEAR
? SOUNDEX('Smith') = SOUNDEX('Smyth') && Displays .T.
? SOUNDEX('Computer') && Displays C513
See Also
Reference
DIFFERENCE( ) Function
Sound Player Foundation Class
Creating Character Expressions