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 function will work with values out of range?

Next time, I will be exploring the PATINDEX() function.

Related posts

One Thought to “String Functions – NCHAR()”

  1. dvbt

    Awsome site! I am loving it!! Will be back later to read some more. I am bookmarking your feeds also.

Leave a Comment