ASCII

Returns the ASCII code for the first character of a string. If the string is empty, 0 is returned.

Syntax

ASCII(expression varchar) → int32

• expression: The string for which the ASCII code for the first character in the string is returned.

Examples

ASCII example

SELECT ASCII ('SPICE')
-- 68

ASCII example

SELECT ASCII ('D')
-- 68

ASCII example

SELECT ASCII ('')
-- 0