NCHAR (SQL Server Compact)

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)) 
FROM Customers