Javatpoint Logo
Javatpoint Logo

ORD Function in SQL

The ORD function of Structured Query Language shows the code of left-most character of the specified string or word. SQL also allows you to perform the ORD function on the String fields of the table.

Syntax of ORD String Function

Syntax1: This syntax uses the ORD 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 ORD string function.

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

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

Examples of ORD String function

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

Output:

ASCII_J
74

Example 2: The following SELECT query returns the ORD value of @ symbol:

Output:

[email protected]
64

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

Output:

ASCII_N
78

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

Output:

ASCII_R
82

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

In this example, we are going to create a new SQL table on which we have to execute the ORD function for finding the ORD 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:


Roll_No First_Name Last_Name First_City Second_City New_City Hindi_Marks Maths_Marks Grade
10 Aman Sharma Lucknow Chandigarh Ghaziabad 88 95 A2
02 Vishal Sharma Chandigarh Ghaziabad Ghaziabad 95 82 A1
07 Raj Gupta Delhi Ghaziabad Lucknow 91 95 A1
04 Yash Singhania Ghaziabad Delhi Lucknow 85 82 A2
11 Vinay Roy Delhi Kanpur Ghaziabad 95 97 A1
16 Manoj Gupta Ghaziabad Meerut Chandigarh 95 90 B1
19 Ram Gupta Lucknow Ghaziabad Chandigarh 89 95 A2

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

This SQL statement shows the code of left-most character of the last name from the table.

Output:

Last_Name ORD_LastName
SHARMA 83
SHARMA 83
GUPTA 71
SINGHANIA 83
ROY 82
GUPTA 71
GUPTA 71

Query 2: The following SELECT query uses the ORD 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:

Roll_No ASCII(First_City) ASCII(Second_City) ASCII(New_City)
07 68 71 76
04 71 68 76
11 68 75 71
16 71 77 67
19 76 71 67

Next Topic#





Youtube For Videos Join Our Youtube Channel: Join Now

Feedback


Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA