chr()

Returns a character which is corresponding the ASCII code value or Unicode code point

Arguments & returns

Scalar

Overload link	`code_point`	Returns
#01	`INTEGER`	`VARCHAR`

SELECT chr(65);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Used in larger rewrites 1

These examples use chr as one part of a larger SQL translation.

SELECT BASE64_ENCODE(x, 76)

In DuckDB

SELECT RTRIM(REGEXP_REPLACE(TO_BASE64(x), '(.{76})', '\1' || CHR(10), 'g'), CHR(10))