upper/ucase¶
This function is used to convert all characters of a string to the upper case.
Syntax¶
upper(string A)
or
ucase(string A)
Parameters¶
Parameter | Mandatory | Type | Description |
|---|---|---|---|
A | Yes | STRING | Text string to be converted |
Return Values¶
The return value is of the STRING type.
Note
If the value of the input parameter is not of the STRING, BIGINT, DOUBLE, DECIMAL, or DATETIME type, an error is reported.
If the value of the input parameter is NULL, NULL is returned.
Example Code¶
Converts lowercase characters in a string to the upper case. An example command is as follows:
The value ABC is returned.
select upper('abc');
The value of the input parameter is NULL. An example command is as follows:
The value NULL is returned.
select upper(null);