CHAR (TSQL Function)

Returns the unicode character corresponding to the unicode code point.

Syntax

CHAR ( integer_expression )

Arguments

integer_expression
is an integer expression of type int.

Return Types

Returns varchar(1).

Remarks

With RSQL, this function can be used with any unicode code point.
With MS SQL Server, only values in the “ascii” range [0, 255] are allowed. Else, the result is NULL.

See also NCHAR.

Examples

PRINT CHAR(65), CHAR(233), CHAR(1060);

The result is:

A|é|Ф|
RSQL, a simple alternative to Microsoft SQL Server