SQL Length Function

The Length function in SQL is used to get the length of a string. This function is called differently for the different databases:

• MySQL: LENGTH()
• Oracle: LENGTH()
• SQL Server: LEN()

The syntax for the Length function is as follows:

Length(str): Find the length of the string str.

Let's take a look at some examples. Assume we have the following table:

Table Geography

region_name	store_name
East	Boston
East	New York
West	Los Angeles
West	San Diego

Example 1:

SELECT Length(store_name)
FROM Geography
WHERE store_name = 'Los Angeles';

Result:

11

Example 2:

SELECT region_name, Length(region_name)
FROM Geography;

Result:

Link to this page: If you find this page useful, we encourage you to link to this page. Simply copy and paste the code below to your website, blog, or profile.

<a href="http://www.1keydata.com/sql/sql-length.html">SQL Length Function</a>