SQL Server Tutorial SQL Server Advanced SQL Server Database SQL Server References

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

integer_code Required. Specify integer whose Unicode character value is to be retrieved.

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:

Datax1x2x3
Data167117116
Data280117116
Data384111111
Data466111119
Data5677968
Data669110100

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:

Datax1x2x3NCHAR_String
Data167117116Cut
Data280117116Put
Data384111111Too
Data466111119Bow
Data5677968COD
Data669110100End

❮ SQL Server Functions