Trusted answers to developer questions
Trusted Answers to Developer Questions

Related Tags

sql

What is CHAR_LENGTH() function in SQL?

Maria Elijah

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.

RELATED TAGS

sql
RELATED COURSES

View all Courses

Keep Exploring