LOWER Function

Converts the case of a character string to lowercase.

See:	UPPER Function

Syntax

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