SQL LEN() | LENGTH() Function

SQL LEN() | LENGTH() Syntax

The basic syntax is to get number of characters available in the string or table column.

For Microsoft Sql Server | Access

// For input string or text

SELECT LEN(string or text);

// For specific table column value

SELECT LEN(column_name1) FROM table_name;

For MySql

// For input string or text

SELECT LENGTH(string or text);

// For specific table column value

SELECT LENGTH(column_name1) FROM table_name;

SQL LEN() | LENGTH() Example - Using Expression Or Formula

The following SQL SELECT statement returns the integer value of a given input string.

For Microsoft Sql Server | Access

SELECT LEN('Hello') AS 'Total Characters';

For MySql

SELECT LENGTH('Hello') AS 'Total Characters';

The result of above query is:

Sample Database Table - Books

SQL LEN() | LENGTH() Example

The following SQL statement selects the "BookName" and "BookPrice" column and find the length of the values from the "Books" table:

For Microsoft Sql Server | Access

SELECT BookID, 
BookName, LEN(BookName) As 'Length Of BookName', 
BookPrice, LEN(BookPrice) As 'Length Of BookPrice' 
FROM Books;

For MySql

SELECT BookID, 
BookName, LENGTH(BookName) As 'Length Of BookName', 
BookPrice, LENGTH(BookPrice) As 'Length Of BookPrice' 
FROM Books;

The result of above query is: