CHR scalar function

Returns the character that has the ASCII code value specified by the argument.

Read syntax diagramSkip visual syntax diagramCHR(expression)

The schema is SYSFUN.

expression
An expression that returns a value of INTEGER or SMALLINT data type.

The result of the function is CHAR(1). The result can be null; if the argument is null, the result is the null value. If the argument value is between 1 and 255, the result is the character that has the ASCII code value corresponding to the argument. If the argument value is 0, the result is the blank character (X'20'). Otherwise the result is the same as CHR(255).