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 dataINSERT INTO ProductVALUES (101,'T-shirt','$100','oo-01-345');INSERT INTO ProductVALUES (102,'Hand Bag','$65','oo-01-238');INSERT INTO ProductVALUES (103,'Ipad','$1200','oo-01-103');INSERT INTO ProductVALUES (104,'Cereal','$30','oo-01-775');INSERT INTO ProductVALUES (105,'Microwave','$520','oo-01-788');INSERT INTO ProductVALUES (106,'cloth clips','$15','oo-01-924');INSERT INTO ProductVALUES (108,'Zara Perfume','$120','oo-01-245');-- QuerySELECT product_name, CHAR_LENGTH(product_name) AS chlen_nameFROM Product;
Explanation
In the code above:
- Line 1–7: We create a table called
Productwith the columnsid,product_name,price,andbook_id. - Line 9–22: Insert data into the
Producttable. - Line 24–26: We return the number of characters in the given string
product_namecolumn using theCHAR_LENGTH()function.
TRENDING TOPICS
