The following query returns the numeric representation of the first character in the string 'hello' according to the ASCII character encoding scheme.
SELECT (ascii('hello') RETURNS INTEGER);
The output returned by the query is:
ascii('hello') -------------- 104