Link Search Menu Expand Document

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