ChAR, CHR – Convert ASCII code to character – Character Functions

CHAR(for SQL Server) and CHR(for Oracle) can convert ASCII code to character.
This is opposite function of ASCII function.

example: Convert ASCII to character.

SELECT ascii_code, CHAR(ascii_code) FROM tbTestTable;

ascii_code       CHAR(ascii_code)
—————————————————
97                   a
98                   b
99                   c
120                  x
121                  y
122                  z
65                   A
66                   B
67                   C
88                   X
89                   Y
90                   Z

Posted in Character Functions