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.
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
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ak05210_ |