SQL Server : the Unicode character based on the number code

I've discussed Unicode and ASCII characters specifically. In that post, I made a list of numbers and characters for Keypress detection needs in VB6 and VB.NET.

Then how to get the Unicode character based on the number code? We can use NCHAR() function.

Syntax:

NCHAR(number_code)

number_code is the number code in the Unicode standard to return the character for.

Contoh:

SELECT NCHAR(57) char9,  NCHAR(79) charO,

       NCHAR(82) charR,  NCHAR(37) [char%]

Notes: This function is also the opposite of the ASCII() function.