Applies to:  CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 


Description

LOWER returns the lower-cased version of a string.

Supported input column types: STRING

Output column type: STRING

NULL-values: If the value is NULL, the result is NULL

Syntax

LOWER ( table.column )

Example


Convert strings to lower-case.


Query
Column1
LOWER ( "Table1"."Column1" )
Input
Table1
Column1 : STRING
'a '
' '
''
null
' '
'wQfxJd5pkTPd4bjoBwYc4q0P4'
'JeCouStHuBERtFustyPOLoris'
'ÄÖÜäöüß'
'%@#$%^&*()_+'
Output
Result
Column1 : STRING
'a '
' '
''
null
' '
'wqfxjd5pktpd4bjobwyc4q0p4'
'jecousthubertfustypoloris'
'äöüäöüß'
'%@#$%^&*()_+'


  • No labels