LCASE (SYSFUN schema) scalar function

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

Read syntax diagramSkip visual syntax diagramLCASE(expression)

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.