The NCHAR function returns a Unicode character for a given integer value.
It accepts an integer value from 0 to 65535, or a hex value from 0 through 0xFFFF.
If the value provided exceeds the range, a NULL value is returned.
This example returns a Unicode character for the given integer value.
SELECT NCHAR(99) AS 'NCHAR(99)',
NCHAR(188) AS 'NCHAR(188)',
NCHAR(248) AS 'NCHAR(248)',
NCHAR(377) AS 'NCHAR(377)',
NCHAR(650) AS 'NCHAR(650)'
| NCHAR(99) | NCHAR(188) | NCHAR(248) | NCHAR(377) | NCHAR(650) |
|---|---|---|---|---|
| c | ¼ | ø | Ź | ʊ |
Syntax of the NCHAR function.
NCHAR(value)
value -- an integer value from 0 to 65355, or hex value 0 through 0xFFFF.
