Syntax
LOWERCASE(Argument)
Description
The LOWERCASE SQL scalar function returns a string in which all the characters are converted to lower case.
The argument must be a character string.
The function result consists of a data type, a length attribute and a real length matching the argument.
If the value of the argument can be null, the result can also be null.
If the value of the argument is null, the result will also be null.
Example
To convert the string 'ABCDEF' to lower case using the LOWERCASE function:
LOWERCASE('ABCDEF')
The function returns the value 'abcdef'.
List of SQL scalar functions by topic