The LENGTH string function in SQL #sqlqueryinterviewquestionsandanswers

The LENGTH string function in SQL

The LEN() function returns the length of a string.

Note: Trailing spaces at the end of the string is not included when calculating the length. However, leading spaces at the start of the string is included when calculating the length.

LENGTH Function in SQL
The LENGTH string function of Structured Query Language returns the number of characters of the given string or word.

Syntax of LENGTH String Function
Syntax1: This syntax uses the LENGTH function with the column name of the SQL table:

SELECT LENGTH(Column_Name) AS Alias_Name FROM Table_Name;