SQL Length Function

Length Function in SQL is used to return the length of a column, string or variable in bytes or characters.

Understand with Example

The Tutorial illustrate an example from SQL Length Function. To understand it, we create a table Stu_Table. The create table statement is used to create table 'Stu_Table' with the specific table attribute like column name, data type etc.

Create Table Stu_Table

create table Stu_Table(Stu_Id varchar(2), 
Stu_Name varchar(15), Stu_Address varchar(20));

Insert data into Stu_Table

The insert into adds the records or rows to the table 'Stu_Table'.

SQL statement to insert data into table:

insert into Stu_Table values(1,'komal','d 16 sec 3 rohani');
insert into Stu_Table values(2,'ajay','c 224 sec 19 nodia');
insert into Stu_Table values(3,'rakesh','c 225 sec 120 nodia');
insert into Stu_Table values(4,'santosh','a 124 sec 126 nodia');
insert into Stu_Table values(5,'tanuj','a 32 sec 26 nodia');

Stu_Table

+--------+----------+---------------------+
| Stu_Id | Stu_Name | Stu_Address         |
+--------+----------+---------------------+
| 1      | komal    | d 16 sec 3 rohani   |
| 2      | ajay     | c 224 sec 19 nodia  |
| 3      | rakesh   | c 225 sec 120 nodia |
| 4      | santosh  | a 124 sec 126 nodia |
| 5      | tanuj    | a 32 sec 26 nodia   |
+--------+----------+---------------------+

Query

The length(stu_address) helps you to find the length of column stu_address in the table Stu_Table.

select stu_id,stu_name,stu_address,
length(stu_address)from stu_table;

Result

+--------+----------+---------------------+---------------------+
| stu_id | stu_name | stu_address         | length(stu_address) |
+--------+----------+---------------------+---------------------+
| 1      | komal    | d 16 sec 3 rohani   | 17                  |
| 2      | ajay     | c 224 sec 19 nodia  | 18                  |
| 3      | rakesh   | c 225 sec 120 nodia | 19                  |
| 4      | santosh  | a 124 sec 126 nodia | 19                  |
| 5      | tanuj    | a 32 sec 26 nodia   | 17                  |
+--------+----------+---------------------+---------------------+

Related Tags for SQL Length Function:
sql,  c,  string,  function,  fun,  io,  variable,  sed,  column,  char,  return,  byte,  ria,  length,  character,  characters,  unc,  cte,  to,  bytes,  e,  var,  use,  in,  m,  tr,  es,  func,  umn,  s,  urn,  col,  rac,  is,  ha,  ar,  act,  str,  va,  s,  s,  ri,  ring,  th,  st,  ab,  abl,  lum,  on,  ol,  o

More Tutorials from this section

• SQL Example, Codes and Tutorials
• Aggregate Functions
• Backup File With Separator
• Backup Into txt File
• Backup selected records into txt file
• Call Procedure
• Close Cursors in SQL
• Create After Insert Trigger in SQL
• Create Before Insert Trigger in SQL
• Create Before Update Trigger in SQL
• Create Delete Trigger in SQL
• Create a Simple Procedure
• Create After Update Trigger in SQL
• Create a database
• Creating Cursors in SQL
• The Normal Forms
• Database Normalization
• Second Normal Form (2NF)
• Third Normal Form (1NF)
• Data Normalization

Ask Questions?    Discuss: SQL Length Function  

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):