Returns the Unicode character(s) (
nvarchar(2)) corresponding to the integer argument it receives, as defined by the Unicode standard.
- integer expression. Any integer expression that is a positive number between 0 and 65535, or if the collation of the database supports supplementary character (CS) flag, the supported range is between 0 to 1114111. If the integer expression does not fall inside this range,
null is returned.
SELECT NCHAR(257) -- Returns 'ā'
SELECT NCHAR(400) -- Returns 'Ɛ'