SQL Server/T-SQL Tutorial/String Functions/nchar function

Get Character Unicode Values

3>
4> SELECT NCHAR(71), NCHAR(111), NCHAR(111), NCHAR(100), NCHAR(33)
5> GO
- - - - -
G o o d !
(1 rows affected)
1>

NCHAR Returns a Unicode character representing the number passed as a parameter.

5> SELECT NCHAR(105)
6>
14> GO
-
i

The NCHAR() function takes a positive integer between 0 and 65,535 and returns a datatype of nchar(1) with the corresponding Unicode character.

Syntax for NCHAR(): NCHAR ( integer_expression )
7>
8> SELECT NCHAR (252)
9> GO
-
ü
(1 rows affected)