Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Returns the ASCII value of the leftmost character of the given string.
ASCII (str)
str
: any string or binary objectASCII only works with 8-bit characters.
Integer, or NULL if str is NULL.
SELECT ASCII('abracadabra');
+----------------------+
| ASCII('abracadabra') |
+----------------------+
| 97 |
+----------------------+