Open In App

ASCII() Function in SQL Server

Improve
Improve
Like Article
Like
Save
Share
Report

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 :

A a Z z
65 97 90 122



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 :

1 # 9 @
49 35 57 64



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

Last Updated : 07 Oct, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads