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 |
+-----+----------+
© 2022 Molecula Corp. (DBA FeatureBase). All rights reserved.