ASCII() Function in SQL Server
Last Updated :
07 Oct, 2020
The ASCII() function returns the ASCII value of the leftmost character of a character expression.
Syntax :
ASCII(character_expression)
Parameter :
This method accepts a single-parameter as mentioned above and described below :
character_expression :
It can be a literal character, an expression of a string, or a column. If more than one character is entered, it will only return the value for the leftmost character.
Returns :
It returns the ASCII code value of its leftmost character.
Example-1 :
When the arguments hold the single uppercase and lowercase letter.
SELECT ASCII('A') AS A, ASCII('a') AS a,
ASCII('Z') AS Z, ASCII('z') AS z;
Output :
Example-2 :
When the arguments hold the single number and special character.
SELECT ASCII('1') AS [1], ASCII('#') AS #,
ASCII(9) AS [9], ASCII('@') AS [@];
Output :
Example-3 :
When the arguments hold the expression of a string.
SELECT ASCII('GeeksForGeeks');
Output :
71
Example-4 :
Using ASCII() function with table columns.
Table – Player_Details
PlayerId |
PlayerName |
City |
45 |
Rohit Sharma |
Mumbai |
18 |
Virat Kohli |
Bangalore |
7 |
MS Dhoni |
Chennai |
33 |
Hardik Pandya |
Mumbai |
42 |
Sikhar Dhawan |
Delhi |
SELECT PlayerName, ASCII(PlayerName) AS AsciiCodeOfFirstChar
FROM Player_Details;
Output :
PlayerName |
AsciiCodeOfFirstChar |
Rohit Sharma |
82 |
Virat Kohli |
86 |
MS Dhoni |
77 |
Hardik Pandya |
72 |
Sikhar Dhawan |
83 |
Share your thoughts in the comments
Please Login to comment...