SQL Reference

LCASE (SYSFUN schema)

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


[ Top of Page | Previous Page | Next Page ]