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

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » Using SQL » SQL functions » Alphabetical list of functions

 

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
  • SQL/2003   Vendor extension.

Example

The following statement returns the value Y.

SELECT CHAR( 89 );