|
upper()
The
string function
upper()
converts lower case letters into upper case letters.
Syntax of the String Function upper()
upper( char_expression | uchar_expression )
The parameters of the String Function upper()
"char_expression"
The parameter "char_expression" can be a
column name,
variable
or
constant
and must be of one of the
datatypese
char,
varchar,
nchar
or
nvarchar.
If the value of the parameter "char_expression" is
NULL,
the return value will also be NULL.
"uchar_expression"
The parameter "uchar_expression" can be a
column name, variable or constant and must be of one of the
datatypes
unichar
or
univarchar.
If the parameter "uchar_expression" has a value of
NULL,
the return value will also be NULL.
Example for the String Function upper()
select upper("SyBASe 15.0")
go
-----
SYBASE 15.0
See also:
ASE T-SQL - Aggregate Functions,
ascii(),
char(),
char(n),
charindex(),
char_length(),
compare(),
difference(),
lower(),
ltrim(),
patindex(),
replicate(),
reverse(),
right(),
rtrim(),
sortkey(),
soundex(),
space(),
str(),
String Functions,
stuff(),
substring(),
to_unichar(),
uhighsurr(),
ulowsurr(),
uscalar().
|
