DIFFERENCE

Description

Returns an integer measuring the difference between two strings using the SOUNDEX algorithm (DIFFERENCE in Transact-SQL). It counts the common characters of the strings resulting by executing the SOUNDEX algorithm.

Sample Source Pattern

Syntax

DIFFERENCE( expression1, expression1 )

Arguments

expression1, expression2: String expressions to be compared.

Return Type

Int.

Examples

Query

SELECT DIFFERENCE('Like', 'Mike');

Result

    Output |
-----------|
         3 |