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

Description

UPPER returns the upper-cased version of a string.

Supported input column types: STRING

Output column type: STRING

Unicode support: The following characters are supported by UPPER:

  • The characters in the range a-z are converted to A-Z.
  • The character ä is converted to Ä.
  • The character ö is converted to Ö.
  • The character ü is converted to Ü.

Syntax

UPPER ( table.column ) 

NULL handling

If the value is NULL, the result is NULL as well.

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
' '


See also:

  • No labels