DIFFERENCE
The function DIFFERENCE returns an integer that is the difference between 2 SOUNDEX string expressions. The return value is within the range of 0 to 4.
| SQL Syntax: |
DIFFERENCE( expression1, expression2 ) | |
| Parameters: |
expression1expression2
|
|
| Escape Syntax: |
{fn DIFFERENCE( expression1, expression2 ) } | |
| Return Type: |
INT |
Examples:
SELECT DIFFERENCE( 'Schmidt', 'Schmidt'), {fn DIFFERENCE( 'Peter', 'Jonathan')}
Return Values: 4, 0
see also:
SQL String Functions
SOUNDEX