Navigation:  »No topics above this level«

DIFFERENCE()

Advantage Concepts

Return to chapter overview

Scalar function that computes the difference of the SOUNDEX values of two strings.

Supported in SQL:

Yes

Supported in Navigational:

Yes

Syntax

DIFFERENCE( <cStr1>, <cStr2> ) à nResult

Parameters

<cStr1>, <cStr2>

Character values.

Return Value

A value measuring the SOUNDEX difference between <cStr1> and <cStr2>.

Remarks

DIFFERENCE() returns an integer value that indicates the difference between the values returned by the SOUNDEX() function for <cStr1> and <cStr2>. The value returned will be in the range 0 to 4. The value 4 indicates the closest match (it means that the soundex encoding of str1 and str2 are identical). The value 0 indicates the lowest possible phonetic match, with the values 1, 2, and 3 indicating increasing degrees of phonetic matching.

See Also

SOUNDEX()