Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: Databricks SQL
Databricks Runtime
Returns the character at the supplied UTF-16 code point. This function is a synonym for char
function.
Syntax
chr(expr)
Arguments
expr
: An expression that evaluates to an integral numeric.
Returns
The result type is STRING.
If the argument is less than 0, an empty string is returned.
If the argument is larger than 255
, it is treated as modulo 256.
This implies char
covers the ASCII and Latin-1 Supplement range of UTF-16.
Examples
> SELECT chr(65);
A