Converting a Character Value to ASCII and Back to Character : ASCII « String Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. String Functions
  3. ASCII
34>
35> SELECT ASCII('H'), ASCII('e'), ASCII('l'), ASCII('l'), ASCII('o')
36> GO

----------- ----------- ----------- ----------- -----------
         72         101         108         108         111

(1 rows affected)








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