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

Related functions

• chr function
• char function