LOWER or LCASE

Translates the argument to lowercase. The argument must be a character or graphic string.

Example:

Ensure that the characters in the value of column NAME are lowercase. NAME has a data type of VARCHAR(30) and a value of 'Christine Smith'.

LCASE(NAME)

The result is the value 'christine smith'.