Syntax
UPPER_CASE(Argument)
Description
The UPPER_CASE SQL scalar function returns a string in which all the characters have been converted to uppercase characters.
The argument must be a character string.
The result of the function has the same data type, length attribute, and actual length as the argument.
If the argument can be null, the result can be null; if the argument is null, the result is the null value.
Example
Uppercase the string 'abcdef' using the UPPER_CASE scalar function.
UPPER_CASE('abcdef')
Returns the value 'ABCDEF'.
List of SQL scalar functions by topic