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.0 KiB

Raw Permalink Blame History

lower/lcase

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

Syntax

lower(string A) / lcase(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 uppercase characters in a string to the lower case. An example command is as follows:

The value abc is returned.

select lower('ABC');

The value of the input parameter is NULL. An example command is as follows:

The value NULL is returned.

select lower(null);

Parent topic: String Functions

5.0 KiB Raw Permalink Blame History