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.

Parent topic: Alphabetical List of Functions
Related reference
SOUNDEX Function [String]