SQL Server/T-SQL/String Functions/ASCII
ASCII("A"): A is 65
<source lang="sql">
1> 2> 3> SELECT ASCII("A") 4> GO
65
(1 rows affected)
</source>
ASCII:return the ASCII numeric value of the leftmost character of a string
<source lang="sql">
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.sqle.ru" 6> SELECT ASCII(@ASCII_STRING) 7> GO
119
(1 rows affected) 1>
</source>