LENGTH Function in SQL

The LENGTH string function of Structured Query Language returns the number of characters of the given string or word.

Syntax of LENGTH String Function

Syntax1: This syntax uses the LENGTH function with the column name of the SQL table:

In the syntax, we have to specify the name of that column on which we want to perform the LENGTH string function for finding the number of characters of each value.

Syntax2: This syntax uses the LENGTH function with the string:

Examples of LENGTH String function

Example 1: The following SELECT query shows the total number of characters of the given JAVATPOINT word:

Output:

LENGTH_word
11

Example 2: The following SELECT query shows the total number of characters of the given string:

Output:

LENGTH_string
28

Example 3: The following SELECT query shows the length of the given sentence:

Output:

LENGTH_Sentence
33

Example 4: The following SELECT query shows the length of the given string:

Output:

LENGTH_space
1

Example 5: The following SELECT query shows the length of the NULL word:

Output:

Length
NULL

Example 6: This example uses the LENGTH function with the table in Structured Query Language.

In this example, we will create a new SQL table on which we want to execute the LENGTH function.

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

CREATE TABLE table_name
(
First_Column_of_table Data Type (character_size of First Column),  
Second_Column_of_table Data Type (character_size of the Second column ),  
Third_Column_of_table Data Type (character_size of the Third column),  
...  

Last_Column_of_table Data Type (character_size of the Last column)
);  

The following CREATE statement creates the Employee_Grade table:

CREATE TABLE Employee_Grade
(
Employee_ID INT PRIMARY KEY,  
First_Name VARCHAR (100),  
Last_Name VARCHAR (100), 
First_City Varchar(120),
Second_City Varchar(120),
New_City Varchar(120),
Attendance_Remarks INT, 
Work_Remarks INT, 
Grade Varchar (80)
);

The below INSERT queries insert the records of Employees with Grades and Remarks in the Employee_Grade table:

INSERT INTO Employee_Grade (Employee_ID, First_Name, Last_Name, First_City, Second_City, New_City, Attendance_Remarks, Work_Remarks, Grade) VALUES (10, Ramesh, Sharma, Lucknow Aurangabad, Ghaziabad, 88, 95, A2);

INSERT INTO Employee_Grade 
(Employee_ID, First_Name, Last_Name, First_City, Second_City, New_City, Attendance_Remarks, Work_Remarks, Grade) 
VALUES ( 02, Yadu, Sharma, Aurangabad, Ghaziabad, Noida, 95, 82, A1 );

INSERT INTO Employee_Grade 
(Employee_ID, First_Name, Last_Name, First_City, Second_City, New_City, Attendance_Remarks, Work_Remarks, Grade) 
VALUES (07, Vijay, Ramna, Noida, Ghaziabad, Lucknow, 91, 95, A1);

INSERT INTO Employee_Grade 
(Employee_ID, First_Name, Last_Name, First_City, Second_City, New_City, Attendance_Remarks, Work_Remarks, Grade)  
VALUES (04, Bhanu, Rangopalr, Ghaziabad, Noida, Lucknow, 85, 82, A2);

INSERT INTO Employee_Grade 
(Employee_ID, First_Name, Last_Name, First_City, Second_City, New_City, Attendance_Remarks, Work_Remarks, Grade) 
VALUES (11, Harry, Roy, Noida, Kanpur, Ghaziabad, 95, 97, A1);

INSERT INTO Employee_Grade 
(Employee_ID, First_Name, Last_Name, First_City, Second_City, New_City, Attendance_Remarks, Work_Remarks, Grade) 
VALUES (16, Akash, Ramna, Ghaziabad, Meerut, Aurangabad, 95, 90, B1);


INSERT INTO Employee_Grade 
(Employee_ID, First_Name, Last_Name, First_City, Second_City, New_City, Attendance_Remarks, Work_Remarks, Grade) 
VALUES (19, Ram, Ramna, Lucknow, Ghaziabad, Aurangabad, 89, 95, A2);

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

Employee_ID	First_Name	Last_Name	First_City	Second_City	New_City	Attendance_Remarks	Work_Remarks	Grade
10	Ramesh	Sharma	Lucknow	Aurangabad	Ghaziabad	88	95	A2
02	Yadu	Sharma	Aurangabad	Ghaziabad	Ghaziabad	95	82	A1
07	Vijay	Ramna	Noida	Ghaziabad	Lucknow	91	95	A1
04	Bhanu	Rangopalr	Ghaziabad	Noida	Lucknow	85	82	A2
11	Harry	Roy	Noida	Kanpur	Ghaziabad	95	97	A1
16	Akash	Ramna	Ghaziabad	Meerut	Aurangabad	95	90	B1
19	Ram	Ramna	Lucknow	Ghaziabad	Aurangabad	89	95	A2

Query 1: The following SELECT query uses the LENGTH function with the First_Name column of the above Employee_Grade table:

This statement shows the length of the first name of each employee who works in the industry.

First_Name	LENGTH_FirstName
Ramesh	6
Yadu	4
Vijay	5
Bhanu	5
Harry	5
Akash	5
Ram	3

Query 2: The following SELECT query uses the LENGTH function with the Last_Name column of the above Employee_Grade table:

This statement shows the length of the last name of each employee.

Output:

Last_Name	LENGTH_LastName
Sharma	6
Sharma	6
Ramna	5
Rangopalr	9
Roy	3
Ramna	5
Ramna	5

Query 3: The following SELECT query uses the LENGTH function with the First_City and New_City column of the above Employee_Grade table:

SELECT First_City, LENGTH(First_City) AS LENGTH_FirstCity, New_City, LENGTH(New_City) AS LENGTH_NewCity FROM Employee_Grade;

This SQL statement shows the length of the first and new city of each employee.

Output:

First_City	LENGTH_FirstCity	New_City	LENGTH_NewCity
Lucknow	7	Ghaziabad	9
Aurangabad	10	Ghaziabad	9
Noida	5	Lucknow	7
Ghaziabad	9	Lucknow	7
Noida	5	Ghaziabad	9
Ghaziabad	9	Aurangabad	10
Lucknow	7	Aurangabad	10

Next TopicREVERSE String Function in SQL

← prev next →

Latest Courses

We provides tutorials and interview questions of all technology like java tutorial, android, java frameworks

Contact info

G-13, 2nd Floor, Sec-3, Noida, UP, 201301, India

[email protected].

Python

AI, ML and Data Science

Java

B.Tech and MCA

Web Technology

Software Testing

Technical Interview

Java Interview

Web Interview

Database Interview

Company Interviews

SQL Tutorial

SQL Database

SQL Table

SQL Select

SQL Clause

SQL Order By

SQL Insert

SQL Update

SQL Delete

SQL Join

SQL Keys

Difference

SQL Injection

SQL String Functions

Misc

SQL MCQ

PL/SQL Tutorial

Interview

Quiz

LENGTH Function in SQL

Syntax of LENGTH String Function

Examples of LENGTH String function

Latest Courses

Contact info

Follow us

Tutorials

Interview Questions

Online Compiler