ASCII(string_exp)

Returns the ASCII code value of the leftmost character of string_exp as an integer.

 

Example:

SELECT ASCII('CONNX') returns 67 (ASCII code for 'C')