>>-LCASE--(--expression--)-------------------------------------><
The schema is SYSFUN.
Returns a string in which all the characters A-Z have been converted to the characters a-z (characters with diacritical marks are not converted). Note that LCASE(UCASE(string)) will therefore not necessarily return the same result as LCASE(string).
The argument can be of any built-in character string type. For a VARCHAR the maximum length is 4 000 bytes and for a CLOB the maximum length is 1 048 576 bytes.
The result of the function is:
The result can be null; if the argument is null, the result is the null value.