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