NCHAR (SQL Server Compact Edition)
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 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)) FROM Customers