Returns the Unicode character with the given integer code, as defined by the Unicode standard.
NCHAR ( integer_expression )
A positive integer from 0 through 65535. integer_expression can also be of a data type that can be implicitly converted to int within the specified range. If a value outside this range is specified, NULL is returned.
The following example returns the first letter of each company name listed in the Customers table.
SELECT CompanyName, NCHAR(UNICODE(CompanyName))