ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

CHAR function [String]

Function 

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.

Usage 

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.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Compatible with Adaptive Server Enterprise.

Example 

The following statement returns the value Y.

SELECT CHAR( 89 )