CHAR_LENGTH Function in SQL

The CHAR_LENGTH string function of Structured Query Language returns the number of characters of the given string or word.

Syntax of CHAR_LENGTH String Function

Syntax1: This syntax uses the CHAR_LENGTH function with the column name of the SQL table:

In this first syntax, we have to specify the name of that column on which we want to execute the CHAR_LENGTH string function for finding the number of characters of each value.

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

Examples of CHAR_LENGTH String function

Example 1: The below query shows the total number of characters of the given JAVATPOINT word:

Output:

Example 2: The following SELECT query shows the total number of characters of the given string:

SELECT CHAR_LENGTH('JAVATPOINT is a good website') AS CHAR_LENGTH_string;

Output:

Example 3: The following SELECT query shows the CHAR_LENGTH 16 characters from the given sentence:

SELECT CHAR_LENGTH( 'NEW DELHI IS THE CAPITAL OF INDIA') AS CHAR_LENGTH_Sentence;

Output:

Example 4: The following SELECT query shows the length of the given string:

SELECT CHAR_LENGTH( ' ' ) AS CHAR_LENGTH_space;

Output:

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

SELECT CHAR_LENGTH( NULL ) AS Length;

Output:

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

In this example, we are going to create a new SQL table on which we want to execute the Char_Length function.

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

The following CREATE statement creates the Worker_Grade table:

The below INSERT queries insert the records of Workers with Grades and Remarks in the Worker_Grade table:

The following SELECT statement displays the inserted records of the above Worker_Grade table:

Query 1: The following SELECT query uses the CHAR_LENGTH function with the First_Name column of the above Worker_Grade table:

This statement shows the length of the first name of each worker.

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

This statement shows the length of the last name of each worker.

Output:

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

This SQL statement shows the length of the first and new city of each worker.

Output: