|
soundex()
The
string function
soundex()
returns a four character "sound-code", which corresponds to the sound of an
expression.
Syntax of the String Function soundex()
soundex ( char_expression | uchar_expression )
The parameters of the String Function soundex()
"char_expression"
The parameter "char_expression" can be a
column name,
variable
or
constant
and must be of one of the
datatypes
char,
varchar,
nchar
or
nvarchar
If the parameter "char_expression" has a value of
NULL
then NULL will also be returned.
"uchar_expression"
The parameter "uchar_expression" can be a
column name, variable or constant an must be of one of the
datatypes
unichar
or
univarchar
If the parameter "uchar_expression" has a value of
NULL
then NULL will also be returned.
Example for the String Function soundex()
select soundex("smith"), soundex("smythe")
go
----- -----
S530 S530
select soundex("sybase"), soundex("saibais")
go
----- -----
S120 S120
See also:
ASE T-SQL - Aggregate Functions,
ascii(),
char(),
char(n),
charindex(),
char_length(),
compare(),
difference(),
lower(),
ltrim(),
patindex(),
replicate(),
reverse(),
right(),
rtrim(),
sortkey(),
space(),
str(),
String Functions,
stuff(),
substring(),
to_unichar(),
uhighsurr(),
ulowsurr(),
upper(),
uscalar().
|
