The SQL Procedure

LOWER function

Converts the case of a character string to lowercase.

See also:

LOWER (sql-expression)

sql-expression: must resolve to a character string and is described in sql-expression.

The LOWER function operates on character strings. LOWER changes the case of its argument to all lowercase.

Note: The LOWER function is provided for compatibility with the ANSI SQL standard. You can also use the SAS function LOWCASE. [cautionend]