LCASE (SYSFUN schema) scalar function
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
The schema is SYSFUN.
- An expression that returns a built-in character string. 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.
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.