LENGTH
All functions > STRING > LENGTH
Returns the number of characters in a string.
Syntax
LENGTH(expr)sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
string | VARCHAR | Yes | Input string to measure |
Returns
Number of characters in the string
Notes
- Counts characters, not bytes
- Spaces and special characters are counted
- Unicode characters (emoji, symbols) count as single characters
- Aliases: LEN, SIZE
Aliases
LENSIZE