DIFFERENCE Function [String]

Compares two strings, evaluates the similarity between them, and returns a value from 0 to 4.

The best match is 4.

Syntax

DIFFERENCE ( string-expression1, string-expression2 )

Parameters

Parameters
Parameter	Description
string-expression1	The first string to compare.
string-expression2	The second string to compare.

Returns

SMALLINT

Standards and Compatibility

SQL—Vendor extension to ISO/ANSI SQL grammar.
Sybase—Compatible with Adaptive Server Enterprise.

DIFFERENCE Function Examples
Use the examples as reference for DIFFERENCE function usage.

Parent topic: Alphabetical List of Functions

Related reference

SOUNDEX Function [String]

Created June 28, 2012. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com