LENGTH
Calculates the length of the input string.
Syntax
LENGTH(<expression>)
Parameters
| Parameter | Description | Supported input types |
|---|---|---|
<expression> | The string or binary data for which to return the length. | TEXT, BYTEA |
Return Type
INTEGER
Example
Use the LENGTH to find the length of any string, such as:
SELECT LENGTH('The Accelerator Cup')
Spaces are included in the calculation of the total length of the string.
Returns: 19