SQL Server LEN Function Examples
Let’s look at some examples of the LEN function in SQL Sever and understand it works.
Return the length of a string using LEN function Example
In this example, we will use the SQL LEN function on a string to get its length.
Query:
SELECT LEN('w3wiki');
Output :
13
Check if LEN() Function count trailing spaces or not Example
In this example, we will use the SQL LEN function on a string with trailing spaces and check the output.
Query
SELECT LEN('GFG ')
AS Length_with_trailing_spaces;
Output :
| Length_with_trailing_spaces |
|---|
| 3 |
Check if LEN() Function count leading spaces or not Example
In this example, we will use the LEN function to check if it counts the leading spaces in a string.
Query:
SELECT LEN(' GFG')
AS Length_with_leading_spaces;
Output:
| Length_with_leading_spaces |
|---|
| 10 |
Using LEN() function on a column Example
Consider the following table, in this example, we will use the SQL LEN function on the entire column of a table in SQL Server.
Table — Player_Details
| PlayerId | PlayerName | >City |
|---|---|---|
| 45 | Rohit Sharma | Mumbai |
| 18 | Virat Kohli | Bengaluru |
| 7 | M S Dhoni | Chennai |
Query:
SELECT PlayerName, LEN(PlayerName) PlayerName_Length
FROM Player_Details
Output :
| PlayerName | PlayerName_Length |
|---|---|
| Rohit Sharma | 12 |
| Virat Kohli | 11 |
| MS Dhoni | 8 |
SQL Server LEN() Function
SQL SERVER LEN() function calculates the number of characters of an input string, excluding the trailing spaces.