SQL Reference

LCASE or LOWER

>>--+-LCASE-+---(--string-expression--)------------------------><
    '-LOWER-'
 

The schema is SYSIBM. ⁴²

The LCASE or LOWER function returns a string in which all the SBCS characters have been converted to lowercase characters (that is, the characters A-Z will be translated to the characters a-z, and characters with diacritical marks will be translated to their lower case equivalents if they exist. For example, in code page 850, É maps to é). Since not all characters are translated, LCASE(UCASE(string-expression)) does not necessarily return the same result as LCASE(string-expression).

The argument must be an expression whose value is a CHAR or VARCHAR data type.

The result of the function has the same data type and length attribute of the argument. If the argument can be null, the result can be null; if the argument is null, the result is the null value.

Example: Ensure that the characters in the value of column JOB in the EMPLOYEE table are returned in lowercase characters.

  SELECT LCASE(JOB) 
    FROM EMPLOYEE WHERE EMPNO = '000020'; 
		

The result is the value 'manager'.

⁴²

The SYSFUN version of this function continues to be available with support for LONG VARCHAR and CLOB arguments. See LCASE (SYSFUN schema) for a description.