The LCASE function returns a string in which all SBCS characters have been converted to lowercase characters, that is, the characters A-Z have been converted to the characters a-z.
Characters with diacritical marks are not converted.
Consequently, a statement of the form LCASE(UCASE(string)) will not necessarily return the same result as LCASE(string).

The schema is SYSFUN.

expression

An expression that returns a built-in character string or Boolean value.
In a Unicode database, the expression can also return a graphic string, in which case it is first converted to a character string before the function is evaluated.
For a VARCHAR, the maximum length is 4000 bytes.
For a CLOB, the maximum length is 1,048,576 bytes.

Result

The data type of the result depends on the data type of the input expression:

• VARCHAR(4000) if the input expression is VARCHAR or CHAR
• CLOB(1M) if the input expression is CLOB or LONG VARCHAR

The result can be null; if the input expression is null, the result is the null value.