ASCII

In This Topic

ASCII(char)

Returns the ASCII code of the first character in the expression.

Example

Returns: 97

Returns: 65

Returns: 65
NOTE: Only the FIRST character is considered for the ASCII operation.  
Use SUBSTRING to get a character from a specific index in a string if required.

SELECT ASCII('A test')

SELECT ASCII('A')

SELECT ASCII('a')