ASCII

The ASCII function returns the ASCII code value of the leftmost character of the argument as an integer.

Example:

Return the integer value for the ASCII representation of 'A'.

SELECT ASCII('A') 
FROM SYSIBM.SYSDUMMY1 

Returns the value 65.