Skip to main content

PQL47 (PQL Function Library - CPM 4.7)

TO_STRING

Applies to: CELONIS 4.7

Description

TO_STRING converts INT input to STRING output.

Supported input column type: INT.

Output column type: STRING.

Syntax
TO_STRING ( table.column ) 
Null handling

If the input value is NULL, the output value is NULL as well.

Example

[1] Convert integers to strings. NULL input is also NULL in the output:

Query

Column1

TO_STRING ( "Table1"."Column1" )

Input

Output

Table1

Column1 : INT

null

0

100

-200

-9223372036854775808

9223372036854775807

Result

Column1 : STRING

null

'0'

'100'

'-200'

'-9223372036854775808'

'9223372036854775807'

See also: