js editor
Web development
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 | |