What is CHAR_LENGTH() function in SQL?

Overview

In SQL, we use the CHAR_LENGTH() function to return the count of characters in a given string.

Syntax

CHAR_LENGTH(string)

Parameter

  • string: This represents the string whose character length will be returned.

Note: The space is counted if a string contains a space.

Example

The following code shows how to use the CHAR_LENGTH() function in SQL.

CREATE TABLE Product (
    id int,
    product_name varchar(50),
    price varchar(50),
    product_id varchar (20)
);
-- Insert data
INSERT INTO Product
VALUES (101,'T-shirt','$100','oo-01-345');
INSERT INTO Product
VALUES (102,'Hand Bag','$65','oo-01-238');
INSERT INTO Product
VALUES (103,'Ipad','$1200','oo-01-103');
INSERT INTO Product
VALUES (104,'Cereal','$30','oo-01-775');
INSERT INTO Product
VALUES (105,'Microwave','$520','oo-01-788');
INSERT INTO Product
VALUES (106,'cloth clips','$15','oo-01-924');
INSERT INTO Product
VALUES (108,'Zara Perfume','$120','oo-01-245');
-- Query 
SELECT product_name, CHAR_LENGTH(product_name) AS chlen_name
FROM Product;

Explanation

In the code above:

  • Line 1–7: We create a table called Product with the columns id, product_name, price, and book_id.
  • Line 9–22: Insert data into the Product table.
  • Line 24–26: We return the number of characters in the given string product_name column using the CHAR_LENGTH() function.

Free Resources

License: Creative Commons-Attribution-ShareAlike 4.0 (CC-BY-SA 4.0)