Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Function Reference » Alphabetical list of functions

DEGREES function [Numeric] Next Page

DIFFERENCE function [String]

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.


The DIFFERENCE function compares the SOUNDEX values of two strings and evaluates the similarity between them, returning a value from 0 through 4, where 4 is the best match.

This function always returns some value. The result is NULL only if one of the arguments are NULL.

See also
Standards and compatibility

The following statement returns the value 3.

SELECT DIFFERENCE( 'test', 'chest' );