CHR

The CHR function converts an integer value (or any value that can be implicitly converted to an integer value) into a character.

Note:

Use of this function results in code that is not portable between ASCII- and EBCDIC-based architectures.

Return Value

A text value. For single-byte character sets, if number > 256, the function returns the binary equivalent of number MOD 256. For multibyte character sets, number must resolve to one entire code point. Invalid code points are not validated, and the result of specifying invalid code points is indeterminate.

Syntax

CHR(number [ USING NCHAR_CS ])

Parameters

number: An integer value, or any value that can be implicitly converted to an integer value.

See also:
"Automatic Conversion of Numeric Data Types"
USING NCHAR_CS: Specifies that the function returns the value in the national character set. When you do not specify this clause, the function returns the value in the database character set.

Examples

OLADM1544 Example 7-44 Converting an Integer Value Into a Character

Assume that you have an ASCII-based system with the WE8ISO8859P1 database character set. In this case, the following statement returns the letter C.

SHOW CHR(67)
C