|
|
|
|
|
|
|
|
|
|
version 11
ASCII (arithmetic_expression)
Description
The ASCII function returns the leftmost character of the arithmetic_expression as an integer. If the arithmetic_expression is null, the function will return a NULL value.
Example
This example returns the first letter of each last name as an integer:
SELECT ASCII(SUBSTRING(LastName,1,1)) FROM PEOPLE;
|
|
|
|
|
|
|
|
|
|