CHR
CHR converts an integer ASCII code to a character.
Syntax
CHR (integer)
Remarks
• CHR can accept string input, as long as the string can be converted to a numeric value.
• The input must be a value between 0 and 255, inclusive.
• If the input is NULL, the output is NULL.
• If the input is less than zero, an exception is thrown.
• If the input is greater than the maximum value of INTEGER (2147483647), an exception is thrown.
• For an ASCII chart, see http://www.techonthenet.com/ascii/chart.php
The following table lists the input types that you can use in CHR, and their corresponding output types.
Data Type of integer | Output Type |
BIGINT, DECIMAL, INTEGER, SMALLINT, STRING, TINYINT | CHAR(1) |
NULL | NULL |
Example
SELECT DISTINCT CHR (100)
FROM /shared/examples/ds_orders/customers