MySQL ASCII() Function

Return the ASCII value of the first character in "CustomerName":

SELECT ASCII(CustomerName) AS NumCodeOfFirstChar
FROM Customers;

Definition and Usage

The ASCII() function returns the ASCII value for the specific character.

ASCII( character)

Parameter	Description
character	Required. The character to return the ASCII value for. If more than one character is entered, it will only return the value for the first character

Works in:	From MySQL 4.0