String Functions – NCHAR()

I am going to continue my series of very short articles or tidbits on Transaction SQL string functions. I will exploring the NCHAR() function today. The NCHAR() function takes an integer value, UNICODE value from 0 to 65535 and returns a single UNICODE character string. The following example returns the character ‘0’ given the UNICODE value of 48.

One thing to always worry about when using TSQL functions is how will it react with a UNKNOWN or NULL values?

Another thing to test is how the…