Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

CHAR is the reverse of the ASCII function as it changes a numeric value in to an ASCII character

4> DECLARE @ASCII_VALUE INT 5> SET @ASCII_VALUE = 82 6> SELECT CHAR(@ASCII_VALUE) 7> GO - R (1 rows affected)