4.9.2.30 DIFFERENCE function (ODBC compatible)

Syntax

DIFFERENCE ( string_exp1,string_exp2 )

Description

The scalar function DIFFERENCE returns an integer value that indicates the difference between the values returned by the SOUNDEX function for string_exp1 and string_exp2.

Example

SELECT DIFFERENCE(name,'Robets')
FROM customer
WHERE  name = 'Roberts';

DIFFEREN

       2
1 record selected

Notes

• The arguments of the function can be of the type fixed length or variable length CHARACTER.
• The result is INTEGER.
• If the argument expression evaluates to null, the result is null.