ASCII returns the ASCII numeric value of the leftmost character of a string. : ASCII « String Functions « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. String Functions
3. ASCII

Only the first character in the string is evaluated.

40> DECLARE @ASCII_STRING CHAR(5)
41> SET @ASCII_STRING = "www.java2s.com java2s"
42> SELECT ASCII(@ASCII_STRING)
43> GO

-----------
        119

(1 rows affected)