String

CHR

Snowflake

Mengkonversi ASCII/Unicode code point menjadi karakter. Kebalikan dari ASCII.

Tipe hasil: VARCHARDiperbarui: 6 Jan 2026

Syntax

SQL

CHR(code)

codeINTEGERwajib

ASCII atau Unicode code point

SQL

1 SELECT
2   CHR(65) as char_a,
3   CHR(97) as char_lower_a,
4   CHR(10) as newline,
5   CHR(9) as tab;

Mengkonversi ASCII codes ke karakter.

Hasil

CHAR_A	CHAR_LOWER_A
A	a

SQL

1 SELECT LISTAGG(CHR(64 + seq4()), '') as alphabet
2 FROM TABLE(GENERATOR(ROWCOUNT => 26));

Membuat string alfabet menggunakan CHR.

Hasil

ABCDEFGHIJKLMNOPQRSTUVWXYZ

SQL

1 SELECT 'Line1' || CHR(10) || 'Line2' as multiline;

Memasukkan newline character.

1	SELECT LISTAGG(CHR(64 + seq4()), '') as alphabet
2	FROM TABLE(GENERATOR(ROWCOUNT => 26));