SQL Reference Guide

CHAR function (ODBC compatible)

Syntax

CHAR ( integer_expression )

Description

The scalar function CHAR returns a character string with the first character having an ASCII value equal to the argument expression. CHAR is identical to CHR but provides ODBC-compatible syntax.

Example

SELECT *

FROM customer

WHERE SUBSTR (zip, 1, 1) = CHAR (53) ;

Notes

• The argument to the function must be of type INTEGER, TINYINT, or SMALLINT.
• The result is of type character.
• If the argument integer_expression evaluates to null, the result is null.