SQL Reference Guide

CHR function (extension)

Syntax

CHR ( integer_expression )

Description

The scalar function CHR returns a character string with the first character having an ASCII value equal to the argument expression.

Example

SELECT *

FROM customer

WHERE SUBSTR (zip, 1, 1) = CHR (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.