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

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

ASCII:return the ASCII numeric value of the leftmost character of a string

1> -- ASCII:return the ASCII numeric value of the leftmost character of a string.
2> -- Only the first character in the string is evaluated.
3>
4> DECLARE @ASCII_STRING CHAR(5)
5> SET @ASCII_STRING = "www.java2s.com"
6> SELECT ASCII(@ASCII_STRING)
7> GO

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

(1 rows affected)
1>
           
       

Related examples in the same category