Su, Xiaomeng 76a5b1ee83 dli_sqlreference_20240227

Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Su, Xiaomeng <suxiaomeng1@huawei.com>
Co-committed-by: Su, Xiaomeng <suxiaomeng1@huawei.com>

2024-03-27 22:02:33 +00:00

5.2 KiB

Raw Permalink Blame History

upper/ucase

This function is used to convert all characters of a string to the upper case.

Syntax

upper(string A)

ucase(string A)

Parameters

**Table 1** Parameter
Parameter	Mandatory	Type	Description
A	Yes	STRING	Text string to be converted

Return Values

The return value is of the STRING type.

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);

Parent topic: String Functions

5.2 KiB Raw Permalink Blame History