On Sun, Oct 5, 2008 at 7:59 AM, Gilles Ganault <[EMAIL PROTECTED]>wrote:
> > This is for an accounting program: As an exemple, all accounts > starting with 6 must be listed together, which means that eg. 6001 > must come after 601, and not after, say, 801. 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) ... HTH Denis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users