ASCII returns the ASCII numeric value of the leftmost character of a string
Only the first character in the string is evaluated. 40> DECLARE @ASCII_STRING CHAR(5) 41> SET @ASCII_STRING = "www.rntsoft.com rntsoft" 42> SELECT ASCII(@ASCII_STRING) 43> GO ----------- 119 (1 rows affected)