Applies to:  CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 


Description

UPPER returns the upper-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

UPPER ( table.column ) 

Example


Convert strings to upper-case.


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


  • No labels