ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

DIFFERENCE function [String]

Function 

Returns the difference in the SOUNDEX values between the two string expressions.

Syntax 

DIFFERENCE ( string-expression-1, string-expression-2  )

Parameters 

string-expression-1    The first SOUNDEX argument.

string-expression-2        The second SOUNDEX argument.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Compatible with Adaptive Server Enterprise.

See also 

SOUNDEX function [String]

Example 

The following statement returns the value 3.

SELECT DIFFERENCE( 'test', 'chest' )