DB2 Version 9.7 for Linux, UNIX, and Windows

LOWER scalar function


>>-LOWER--(--string-expression--)------------------------------><

The schema is SYSIBM. (The SYSFUN version of this function continues to be available with support for CLOB arguments.)

The 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 converted to the characters a-z, and other characters will be converted to their lowercase equivalents, if they exist. For example, in code page 850, É maps to é. If the code point length of the result character is not the same as the code point length of the source character, the source character is not converted. Because not all characters are converted, LOWER(UPPER(string-expression)) does not necessarily return the same result as LOWER(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 as the argument. If the argument can be null, the result can be null; if the argument is null, the result is the null value.

In a Unicode database, if a supplied argument is a graphic string, it is first converted to a character string before the function is executed.

Example:

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

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

The result is the value 'manager'.