Compare strings as numbers in SQLite3 Compare strings as numbers in SQLite3 sqlite sqlite

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