ASA SQL Reference
SQL Functions
Alphabetical list of functions
Returns the difference in the SOUNDEX values between the two string expressions.
DIFFERENCE ( string-expression-1, string-expression-2 )
string-expression-1 The first SOUNDEX argument.
string-expression-2 The second SOUNDEX argument.
SQL/92 Vendor extension.
SQL/99 Vendor extension.
Sybase Compatible with Adaptive Server Enterprise.
The following statement returns the value 3.
SELECT DIFFERENCE( 'test', 'chest' )