CHR

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Returns the character corresponding to a given numeric code.

1chr(<code>)

• <code>: The ASCII code or Unicode code point.

Returns a single character corresponding to the given code.

• For UTF-8, the function treats the argument as a Unicode code point.
• The NULL (0) character isn’t allowed because text data types can’t store NULL bytes.

Get the character for an ASCII code.

1SELECT chr(65) AS result;

Returns 'A'.

• String Types