CHAR is the reverse of the ASCII function as it changes a numeric value in to an ASCII character. : Char function « String Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. String Functions
  3. Char function
4> DECLARE @ASCII_VALUE INT
5> SET @ASCII_VALUE = 82
6> SELECT CHAR(@ASCII_VALUE)
7> GO

-
R

(1 rows affected)








12.2.Char function
12.2.1.CHAR is the reverse of the ASCII function as it changes a numeric value in to an ASCII character.
12.2.2.CHAR(ASCIIValue)
12.2.3.CHAR(13)
12.2.4.A SELECT statement that uses the CHAR function to format output