version 11
CHAR (arithmetic_expression)
Description
The CHAR function returns a fixed-length character string based on the type of the arithmetic_expression passed.
Example
This example returns a character string based on the integer of the first letter of each last name:
SELECT CHAR(ASCII(SUBSTRING(LastName,1,1))) FROM PEOPLE;