Re: [sqlite] Sorting a text field as if it were integer/float

[Tony Fenleish]

Probably late for this replay, but you can convert a string to an integer by 
adding a number:

SELECT ... ORDER BY (catnum + 0);