Compare strings as numbers in SQLite3
Well, found a solution:
SELECT * FROM t1 ORDER BY t1.field + 0
The + 0
part seems to force conversion to number
Well, found a solution:
SELECT * FROM t1 ORDER BY t1.field + 0
The + 0
part seems to force conversion to number