CHR

Return the character corresponding to the given Unicode code point (alias of CHAR).

Syntax

CHR(code)

Description

## Overview Returns the single-character string whose Unicode code point equals the given integer. CHR is the common SQL name for the same function as CHAR and has identical semantics. Use it to generate arbitrary Unicode characters at runtime, including control characters such as tab and line feed. ## Behavior - Returns NULL when the input is NULL. - Accepts code points in the range [0, 0x10FFFF]. - For code point 0, returns a string containing a single NUL character. - Produces a string of length 1 in characters; byte length follows UTF-8 encoding rules. - Surrogate code points (0xD800 through 0xDFFF) have implementation-defined behaviour. - Negative values and values above 0x10FFFF raise an error. ## Compatibility - CHR and CHAR are interchangeable in DeltaForge. - Matches the common SQL convention for code-point conversion.

Parameters

Name	Type	Description
code		Specifies the Unicode code point to convert. Must be a non-negative integer no greater than 0x10FFFF.

Examples

-- Uppercase letter
SELECT CHR(65);  -- 'A'

-- Lowercase z
SELECT CHR(122);  -- 'z'

-- Tab character
SELECT CHR(9);  -- horizontal tab

-- Unicode euro sign
SELECT CHR(8364);  -- '€'

-- NULL propagates
SELECT CHR(CAST(NULL AS INT));  -- NULL

-- Use in a column expression to inject a separator
SELECT first_name || CHR(32) || last_name AS full_name
FROM retail.customers.profiles;

Pitfalls

• CHR produces real control characters. CHR(10) is a line feed that can break single-line consumers.
• CHR(0) is a NUL character and is often treated as string termination by external systems. Avoid in text output unless the consumer tolerates it.
• CHR of a surrogate half yields implementation-defined output.
• Values above 0x10FFFF raise an error. Validate dynamic input against the Unicode range.

See Also

• char
• ascii