Length operator?

Does SeaTable have a Length operator?

Example:

select * from MyTable where length(Col1) < 10

This will get all rows where the length of the value in Col1 is less than 10 characters long.

Hi @nbrege,
Looking at the SQL Function Reference, then len() function seems to be what you’re looking for:

select * from MyTable where len(Col1) < 10

Bests,
Benjamin

Thank you! That was the issue. I looked for that in the documentation but couldn’t find it.

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.