LEN (array)

Function LEN is also found in the following categories: String functions.

SyntaxSyntax

LEN( value )

DescriptionDescription

Returns the number of the value items.

Argument types:

• value — Array of fractional numbers | Array of integers | Array of strings

Return type: Integer

ExamplesExamples

LEN(ARRAY(1, 2, 3)) = 3

LEN(ARRAY('a', 'b', NULL, 'c')) = 4

Data source supportData source support

ClickHouse 21.8, Files, Google Sheets, PostgreSQL 9.3, Yandex Documents.