The ASCII function takes a single argument of any
character data type. It returns an integer value, based on the first
character of the argument, corresponding to the decimal representation
of the codepoint of that character within the ASCII character set.
If the argument is NULL, or if the argument is an empty
string, the ASCII function returns a NULL value.
The following query returns the ASCII value of uppercase H:
SELECT ASCII("HELLO") FROM systables WHERE tabid = 1;
The following table shows the output of this SELECT statement.
(constant)
72
The following query returns the ASCII value of lowercase h:
SELECT ASCII("hello") FROM systables WHERE tabid = 1;
The following table shows the output of this SELECT statement.
(constant)
104
The following query returns the ASCII output from
an empty string argument:
SELECT ASCII("") FROM systables WHERE tabid = 1;
The following table shows the NULL output of this SELECT
statement.
(constant)
The following query returns the ASCII output from
a NULL argument:
SELECT ASCII(NULL) FROM systables WHERE tabid = 1;
The following table shows the NULL output of this SELECT
statement.
(constant)
The ASCII function interprets this argument as a NULL
expression, rather than as a value that begins with uppercase N.