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

For example:
LOWER('Mr Smith') 
returns 'mr smith'.
LOWER('22 Railway Cuttings')
returns '22 railway cuttings'.
LCASE('ABCD')  
returns 'abcd'.

Related concepts
ESQL

Related tasks
Developing ESQL

Related reference
Syntax preference
ESQL string manipulation functions