Category: ASE: Functions: String Functions

difference()

The String Function difference() returns the difference between two soundex()-values as integer. The return value ranges from 0 to 4 with 4 being the best possible match.

Syntax of the String Function difference()

    difference ( expression1 | expression2 )
    

The parameter of the String Function difference()

"expression1" and "expression2"
The parameter "expression1" and "expression2" can either be a column name, a variable or constant and must be available in one of the datatypes char, varchar, nchar, nvarchar or unichar . If one of the two parameters has the value NULL the function will also return NULL.

Example for the String Function difference()

    select difference("smith", "smythi")

    go

    -----

    4
    

    select difference("sybase", "taipase")

    go

    -----

    3
    

See also:

ASE T-SQL - Aggregate Functions,
ascii(),
char(),
char(n),
charindex(),
char_length(),
compare(),
lower(),
ltrim(),
patindex(),
replicate(),
reverse(),
right(),
rtrim(),
sortkey(),
soundex(),
space(),
str(),
String Functions,
stuff(),
substring(),
to_unichar(),
uhighsurr(),
ulowsurr(),
upper(),
uscalar().