SQL Server NCHAR() Function

The SQL Server (Transact-SQL) NCHAR() function returns the Unicode character with the specified integer code, as defined by the Unicode standard.

Syntax

NCHAR(integer_code)

Parameters

Return Value

Returns the Unicode character with the specified integer code, as defined by the Unicode standard.

Example 1:

The example below shows the usage of NCHAR() function.

SELECT NCHAR(72);
Result: 'H'

SELECT NCHAR(69);
Result: 'E'

SELECT NCHAR(NULL);
Result: NULL

SELECT NCHAR('73');
Result: 'I'

Example 2:

Consider a database table called Sample with the following records:

The statement given below can be used to get the string containing Unicode characters given by the code values specified by columns x1, x2 and x3.

SELECT *, NCHAR(x1) + NCHAR(x2) + NCHAR(x3) AS NCHAR_String FROM Sample;

The query will produce the following result: