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