View Source

Generates the Unicode character corresponding to an inputted Integer value.

Unicode is a digital standard for the consistent encoding of the world's writing systems, so that representation of character sets is consistent around the world.

The first 256 Unicode characters (0, 255) correspond to the ASCII character set.
Input values for the CHAR function should be of integer type. Decimal type column data can be used as input. However, if the data contains digits to the right of the decimal point, the CHAR function returns a missing value.
If the function cannot evaluate the numeric data, a null value is returned.

Column reference example:

char(MyCharIndex)

Output: Returns the Unicode value for the number in the MyCharIndex column.

String literal example:

char(65)

Output: Returns the string: A.

char(index_value)

Argument	Required?	Data Type	Description
index_value	Y	integer (positive)	Unicode index value of the character

index_value

Unicode index value of the character to generate or match.

The Unicode character set contains up 1,114,112 characters. Most uses rely on the first 10,000 characters.
Value must be less than end_index.

Required?	Data Type	Example Value
Yes	Integer (non-negative)	`65`

index_value

Example - char and unicode functions