Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

CHAR function [String]

Returns the character with the ASCII value of a number.

CHAR( integer-expression )

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

The character returned corresponds to the supplied numeric expression in the current database character set, according to a binary sort order.

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

• UltraLite String functions

• SQL/2003    Vendor extension.

The following statement returns the value Y.

SELECT CHAR( 89 );