NCHAR Function in SQL Server

NCHAR()
Return a unicode character representing a number passed as a parameter.

Syntax
NCHAR ( integer_expression ) 

Return Types:  character 


Example :
SELECT NCHAR(97)

OutPut

This will return the leter "a"