LOWER and LCASE functions

The LOWER and LCASE functions are equivalent, and manipulate CHARACTER string data; they both return a new character string, which is identical to source_string, except that all uppercase letters are replaced with the corresponding lowercase letters.

Syntax

Read syntax diagramSkip visual syntax diagram LOWERLCASE (source_string)
For example: 
LOWER('Mr Smith')
returns 'mr smith'. 
LOWER('22 Railway Cuttings')
returns '22 railway cuttings'. 
LCASE('ABCD')
returns 'abcd'.