SOUNDEX( ) Function

  • Article

Returns a phonetic representation of the specified character expression.

SOUNDEX(cExpression)

Return Value

Character

Parameters

  • 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.

Example

CLEAR
? SOUNDEX('Smith') = SOUNDEX('Smyth')  && Displays .T.
? SOUNDEX('Computer')  && Displays C513

See Also

Reference

DIFFERENCE( ) Function

Sound Player Foundation Class

Creating Character Expressions

Other Resources

Functions

Language Reference (Visual FoxPro)