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

NOutput

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_example1chr_example2chr_example3

A

Z

0

Last updated