[sqlite] Re: How can I sort a text field numerically?

[Chad Woolley]

On 2/3/06, Chad Woolley <[EMAIL PROTECTED]> wrote:
> We recently upgraded to sqlite3, and I cannot figure out how to get a
> TEXT type field to sort numerically (it's for a Trac report).

Hi,

Thanks to everyone for the help on this.  Here was the simplest thing
that worked:

order by value+0;

Thanks again!

--  Chad