Condividi tramite


SOUNDEX( ) Function

Returns a phonetic representation of the specified character expression.

SOUNDEX(cExpression)

Return Values

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

DIFFERENCE( ) | Sound Player | Creating Character Expressions