SQL Server/T-SQL Tutorial/String Functions/ASCII
ASCII returns the ASCII numeric value of the leftmost character of a string.
<source lang="sql">
Only the first character in the string is evaluated. 40> DECLARE @ASCII_STRING CHAR(5) 41> SET @ASCII_STRING = "www.sqle.ru sqle" 42> SELECT ASCII(@ASCII_STRING) 43> GO
119
(1 rows affected)</source>
Converting a Character Value to ASCII and Back to Character
<source lang="sql">
34> 35> SELECT ASCII("H"), ASCII("e"), ASCII("l"), ASCII("l"), ASCII("o") 36> GO
----------- ----------- ----------- -----------
72 101 108 108 111
(1 rows affected)</source>
Converting an ASCII Value to Character
<source lang="sql">
3> 4> SELECT CHAR(72), CHAR(101), CHAR(108), CHAR(108), CHAR(111) 5> GO - - - - - H e l l o (1 rows affected) 1></source>