SQL Reference Guide

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 are of character types.
• The result is INTEGER.
• If the argument expression evaluates to null, the result is null.