Applies to:  CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 

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


[1] Convert strings to upper-case.

Query
Column1
UPPER ( "Table1"."Column1" )
Input
Table1
Column1 : STRING
'LaTeX'
'PQL'
'Python'
'a '
' '
''
null
' '
Output
Result
Column1 : STRING
'LATEX'
'PQL'
'PYTHON'
'A '
' '
''
null
' '


  • No labels