CHAR function [String]

Returns the character with the ASCII value of a number.

Syntax
CHAR( integer-expression )
Parameters
  • integer-expression   The number to be converted to an ASCII character. The number must be in the range 0 to 255, inclusive.

Returns

VARCHAR

Remarks

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.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Example

The following statement returns the value Y.

SELECT CHAR( 89 );