DB2 Scalar functions - CHR


Volta a página anterior

Volta ao Menu das scalar functions

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

CHR

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

CHR(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).

Related reference



© Copyright IBM Corp.