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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Functions » Alphabetical list of functions

CEILING function [Numeric] Next Page

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.

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
Example

The following statement returns the value Y.

SELECT CHAR( 89 );