|
lower()
The
String Function
lower()
converts upper case letters into lower case letters.
Syntax of the String Function lower()
lower ( char_expression | uchar_expression )
"char_expression"
The parameter "char_expression" can be a
column name,
a variable
or a
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, a variable or a constant and 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 lower()
select lower("SyBASe 15.0")
go
-----
sybase 15.0
See also:
ASE T-SQL - Aggregate Functions, ascii(), char(), char(n), charindex(), char_length(), compare(), difference(), ltrim(), patindex(), replicate(), reverse(), right(), rtrim(), sortkey(), soundex(), space(), str(), String Functions, stuff(), substring(), to_unichar(), uhighsurr(), ulowsurr(), upper(), uscalar().
|