ascii
function
Applies to: Databricks SQL Databricks Runtime
Returns the ASCII code point of the first character of str
.
Syntax
ascii(str)
Arguments
str
: A STRING.
Returns
An INTEGER.
If str
is empty, the result is 0.
If the first character is not an ASCII character or part of the Latin-1 Supplement range of UTF-16, the result is undefined.
Examples
> SELECT ascii('234');
50
> SELECT ascii('');
0