SQL Char Function Example | Char Function In SQL Tutorial is today’s topic. SQL CHAR function is used for converting a numeric value to a character. It is just the opposite of the ASCII function. A character or string function is a function which takes one or more characters or numbers as parameters and returns the character value.
SQL Char Function
The CHAR() function returns a character based on the ASCII code.
See the following syntax.
Select CHAR (number_code)
The number from which character is to be retrieved. An integer outside the range 0 to 255 will return a NULL character.
See the following code.
SELECT CHAR (97);
See the output.
As ASCII value of a is 97 so character a is printed when number 97 was given as an input to …[Read more]