ASCII Function in SQL

The ASCII function of Structured Query Language shows the ascii value of the first character of the string. We can also use the ASCII function with the string fields of the SQL table.

Syntax of ASCII String Function

Syntax1: This syntax uses the ASCII function with the column names of the SQL table:

In the syntax, we have to specify the column's name on which we want to use the ASCII string function.

Syntax2: This syntax uses the ASCII function with the set of characters (string):

Syntax2: This syntax uses the ASCII function with the individual character:

Examples of ASCII String function

Example 1: The following SELECT query shows the ASCII value of the given string:

Output:

Example 3: The following SELECT query shows the ASCII value of the first character of the given string:

Output:

Example 3: The following SELECT query shows the ASCII value of the 'R' character:

Output:

Example 4: This example uses the ASCII function with the SQL table

In this example, we are going to create a new SQL table on which we have to execute the ASCII function for finding the ASCII value of first character.

The syntax for creating the new table in the SQL database is as follows:

The following CREATE statement creates the Student_Grade table:

The below INSERT queries insert the records of students with grades and marks in the Student_Grade table:

The following SELECT statement displays the inserted records of the above Student_Grade table:

Query 1: The following SELECT query uses the ASCII function with the Last_Name column of the above Student_Grade table:

This SQL statement shows the ASCII value of the first character of the last name from the table.

Output:

Query 2: The following SELECT query uses the ASCII function with the First_City, Second_City, and New_City columns of those students whose Roll_No is greater than 2 in the above Student_Grade table:

Output: