you are at Encyclopedia of SQL >> LENGTH
LENGTH( `column_name` )
Functions returns length of given text string as a parameter.
Syntax
SELECT LENGTH(`column_name`)
FROM `table_name`
WHERE `column_name`
In SQL Server there is used function LEN()
Example
Show in one column surname and its length in second column
| name | surname | age |
|---|
| Paweł | Kowalski | 3 |
| Piotr | Janik | 7 |
| Michał | Nowak | 13 |
query
SELECT `surname`,LENGTH(`surname`)
FROM `people`
GROUP BY `surname`
result
| surname | LENGTH(`surname`) |
|---|
| Kowalski | 8 |
| Janik | 5 |
| Nowak | 5 |
[ wróć na górę strony ]
