CHAR function [String]

Returns the character with the ASCII value of a number.

Syntax

CHAR ( integer-expression )

Parameter	Description
integer-expression	The number to be converted to an ASCII character. The number must be in the range 0 to 255, inclusive.

VARCHAR

The following statement returns the value “Y”:

SELECT CHAR( 89 ) FROM iq_dummy

The following statement returns the value “S”:

SELECT CHAR( 83 ) FROM iq_dummy

The character in the current database character set corresponding to the supplied numeric expression modulo 256 is returned.

CHAR returns NULL for integer expressions with values greater than 255 or less than zero.