ASCII() Function in SQL Server

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