Documentation

LEN

LEN() function returns the length of the string expression.

Syntax

len(str_expr)

Arguments

str_expr String expression to find the length of.

Return Type

int

Return Value

len() returns the length of the string expression str_expr.

Remarks

None

Examples

A. Len function on a column.

create table segments
    (_id id, segment string);

insert into segments(_id, segment)
    values (1,'testing')

select _id, len(segment) as length from segments;
+-----+----------+
| _id | length   |
+-----+----------+
|   1 | 7        |
+-----+----------+
Something missing or incorrect?
Help improve this article or join us on Discord!

© 2022 Molecula Corp. (DBA FeatureBase). All rights reserved.