Links

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
Last modified 6mo ago