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.
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.
Do it like thousands of other people who have used SeaTable to develop powerful processes and get their ideas and tasks done more efficiently.