BIT_LENGTH Function in SQL

The BIT_LENGTH string function of Structured Query Language returns the length of the string in bits.

Syntax of BIT_LENGTH String Function

Syntax1: This syntax uses the BIT_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 BIT_LENGTH string function for finding the length of the string in bits.

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

Examples of BIT_LENGTH String function

Example 1: The following SELECT query shows the length of the word in bits:

Output:

BIT_LENGTH_word
80

Example 2: The following SELECT query shows the length of the given string in bits:

Output:

BIT_LENGTH_string
224

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

  SELECT BIT_LENGTH( ‘NEW DELHI IS THE CAPITAL OF INDIA’) AS BIT_LENGTH_Sentence;  

Output:

BIT_LENGTH_Sentence
264

Example 4: The following SELECT query shows the length of the given space in bits:

Output:

BIT_LENGTH_space
8

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

Output:

Length
NULL

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

Here, we are going to create a new SQL table on which we want to execute the BIT_LENGTH function.

The below CREATE TABLE statement is the syntax for creating the new SQL table in the database:

  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 BIT_LENGTH function with the First_Name column of the above Employee_Grade table:

  SELECT First_Name, BIT_LENGTH(First_Name) AS BIT_LENGTH_FirstName FROM Employee_Grade;  

This statement shows the length of the first name of each employee in bits.

First_Name	BIT_LENGTH_FirstName
Ramesh	48
Yadu	32
Vijay	40
Bhanu	40
Harry	40
Akash	40
Ram	24

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

  SELECT Last_Name, BIT_LENGTH(Last_Name) AS BIT_LENGTH_LastName FROM Employee_Grade;  

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

Output:

Last_Name	BIT_LENGTH_LastName
Sharma	48
Sharma	48
Ramna	40
Rangopalr	72
Roy	24
Ramna	40
Ramna	40

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

  SELECT First_City, BIT_LENGTH(First_City) AS BIT_LENGTH_FirstCity, New_City, BIT_LENGTH(New_City) AS BIT_LENGTH_NewCity FROM Employee_Grade;  

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

Output:

First_City	BIT_LENGTH_FirstCity	New_City	BIT_LENGTH_NewCity
Lucknow	56	Ghaziabad	72
Aurangabad	80	Ghaziabad	72
Noida	40	Lucknow	56
Ghaziabad	72	Lucknow	56
Noida	40	Ghaziabad	72
Ghaziabad	72	Aurangabad	80
Lucknow	56	Aurangabad	80

Next TopicCONCAT_WS Function in SQL

BIT_LENGTH Function in SQL

BIT_LENGTH Function in SQL

Syntax of BIT_LENGTH String Function

Examples of BIT_LENGTH String function

SQL Server RENAME Database

How to Delete Column from Table in SQL

You may also like