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_expressioncan also be of a data type that can be implicitly converted to intwithin 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 Customerstable.
SELECT CompanyName, NCHAR(UNICODE(CompanyName))