CHR

Returns the single character string corresponding to the given Unicode code point.

Syntax

CHR(N)

Arguments

N

Type: bigint

An integer representing a Unicode code point value.

Returns

Type: string

The Unicode code point N as a single character string.

Examples

N	Output
65	A
90	Z
48	0
57	9
32	''
97	a
122	z
33	!

Transformation job example

SQL

CREATE JOB function_operator_example
    ADD_MISSING_COLUMNS = true	
    AS INSERT INTO default_glue_catalog.upsolver_samples.orders_transformed_data MAP_COLUMNS_BY_NAME
    SELECT 
        CHR(65) AS chr_example1,
        CHR(90) AS chr_example2,
        CHR(48) AS chr_example3
    FROM default_glue_catalog.upsolver_samples.orders_raw_data 
    WHERE time_filter()
    LIMIT 1;

Query result

chr_example1	chr_example2	chr_example3
A	Z	0