DIFFERENCE( ) Function

Example   See Also

Returns an integer, 0 through 4, which represents the relative phonetic difference between two character expressions.

Syntax

DIFFERENCE(cExpression1, cExpression2)

Returns

Numeric

Arguments

cExpression1, cExpression2

Specifies the character expressions that DIFFERENCE( ) compares.

Remarks

DIFFERENCE( ) is useful for searching tables when the exact spelling of an entry isn't known.

The more alike the two expressions are spelled, the higher the number DIFFERENCE( ) returns. If the character expressions are spelled very similarly, DIFFERENCE( ) returns 4. For two character expressions with little in common phonetically, DIFFERENCE( ) returns 0.