Example Customer Table
The following data table is for example only. Let's use LEN() function to get the length of name from a customer table. The column we going to use is the Name column.
ID | Name | Age |
1 | Thomas Anderson | 45 |
2 | Andrew Golden | 38 |
3 | Ken Tom | 30 |
4 | Andrew Golden | 36 |
5 | Timonthy Kirk | 32 |
6 | Kelly Smith | 39 |
Example of Running SQL Query
SELECT ID, Name, LEN(Name) AS Name_Length FROM Customers
After running the above query, it will return the following result.
ID | Name | Name_Length |
1 | Thomas Anderson | 15 |
2 | Andrew Golden | 13 |
3 | Ken Tom | 7 |
4 | Andrew Golden | 13 |
5 | Timothy Kirk | 11 |
6 | Kelly Smith | 11 |