ascii function

Applies to: check marked yes Databricks SQL check marked yes 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