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 $commit_time BETWEEN run_start_time() AND run_end_time()
    LIMIT 1;

Query result

chr_example1	chr_example2	chr_example3
A	Z	0