String Function – CHAR()

I am going to continue my series of very short articles or tidbits on Transaction SQL string functions. I will exploring the CHAR() function today.

The CHAR() function takes an integer value, ASCII code, from 0 to 255 and returns a single character string.

The following example returns the character ‘0’ given the ASCII code 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 CHARINDEX() function.

Related posts

Leave a Comment