On Sun, 5 Oct 2008 08:52:21 -0600, "Dennis Cote"
<[EMAIL PROTECTED]> wrote:
>It sounds like you want the account numbers to be sorted as text rather than
>numerically, so cast the values to text in the order by clause.
>
>  ... order by cast(account_number as text) ...

Thanks guys. An easier solution was simply to change the column
definition from INTEGER to VARCHAR, since I didn't actually need the
column to be numeric. Sorting works OK now.

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to