Near
Explore posts from serversDTDrizzle Team
•Created by Near on 5/17/2023 in #help
Ordering by a string column but coercing it to a number for ordering
I have a column that mostly contains numbers with only a very few exceptions and want to apply order by, but given the column is of type TEXT the ordering is of course 1, 10, 100, 101, ...
Any suggestions how to coerce the column for ordering? Probably applying the sql tag with an ABS or so?
2 replies