SOUNDEX( ) Function

JavaScript Editor js editor     Web development 



Main Page

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

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

See Also



JavaScript Editor js editor     Web development