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

SQL Anywhere 11.0.1 (Français) » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL functions » SQL functions (A-D)

 

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 );