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

[Dennis Cote]

Tony Fenleish wrote:

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

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

Tony,

You can also do it more explicitly using a cast as shown below.

 SELECT ... ORDER BY CAST(catnum AS INTEGER);

It will return 0 for any string that can't be converted to an integer.

HTH
Dennis Cote