SQL Server/T-SQL/String Functions/CHAR
CHAR(65): 65 is A
<source lang="sql">
1> 2> SELECT CHAR(65) 3> GO - A (1 rows affected) 1>
</source>
CHAR(CAST(0x3A as int))
<source lang="sql">
1> SELECT CHAR(CAST(0x43 as int)) + CHAR(CAST(0x3A as int)) + 2> CHAR(CAST(0x5C as int)) + CHAR(CAST(0x50 as int)) + CHAR(CAST(0x72 as int)) 3> + CHAR(CAST(0x6F as int)) + CHAR(CAST(0x67 as int)) 4> + CHAR(CAST(0x72 as int)) + CHAR(CAST(0x61 as int)) 5> + CHAR(CAST(0x6D as int)) + CHAR(CAST(0x20 as int)) 6> 7> GO
C:\Program (1 rows affected) 1>
</source>
CHAR: the reverse of the ASCII function as it changes a numeric value in to an ASCII character
<source lang="sql">
1> --CHAR: the reverse of the ASCII function as it changes a numeric value in to an ASCII character. 2> 3> DECLARE @ASCII_VALUE INT 4> SET @ASCII_VALUE = 82 5> SELECT CHAR(@ASCII_VALUE) 6> 7> GO - R (1 rows affected) 1>
</source>