Returns the number of characters in a given string.
Example
This example returns the number of characters in the first five entries in the City column.
SELECT City, CHAR_LENGTH(City) as "CityLen"
FROM "Superstore"
GROUP BY City
LIMIT 5;
| City | CityLen |
|---|---|
| Aberdeen | 8 |
| Abilene | 7 |
| Akron | 5 |
| Albuquerque | 11 |
| Alexandria | 10 |