Converting an ASCII Value to Character : ASCII « String Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. String Functions
  3. ASCII
3>
4> SELECT CHAR(72), CHAR(101), CHAR(108), CHAR(108), CHAR(111)
5> GO

- - - - -
H e l l o

(1 rows affected)
1>








12.1.ASCII
12.1.1.ASCII returns the ASCII numeric value of the leftmost character of a string.
12.1.2.Converting a Character Value to ASCII and Back to Character
12.1.3.Converting an ASCII Value to Character