Skip to main content

Celonis Product Documentation

LOWER
Description

LOWER returns the lower-cased version of a string.

Supported input column types: STRING

Output column type: STRING

Unicode support: The following characters are supported by LOWER:

  • 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
 LOWER ( table.column )
NULL handling

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

Example

[1]

Convert strings to lower-case.

Query

Column1

         LOWER ( "Table1"."Column1" )
        

Input

Output

Table1

Column1 : string

'a '

' '

''

null

' '

'LaTeX'

'Python'

'PQL'

'_'

Result

Column1 : string

'a '

' '

''

null

' '

'latex'

'python'

'pql'

'_'

See also: