oh duh. Ignore me. My answer sorts them after the fact with lc. Peters answer does the same basic thing inside sqlite.
On Thu, Jun 4, 2015 at 5:07 PM, Peter Haworth <p...@lcsql.com> wrote: > If the text and numeric portions of the key are indeed separated by an > underscore, the following should work as an ORDER clause (untested). > > ORDER BY substr(TheKeyColumn,1,instr(TheKeyColumn,'_')-1) > ASC,CAST(substr(TheKeyColumn,instr(theKeyColumn,'_')+1) AS INTEGER) ASC > > If there are a fixed number of chars before the numeric part of the key, > then you can replace the instr calls with the appropriate number of chars. > > Pete > lcSQL Software <http://www.lcsql.com> > Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and > SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> > > On Thu, Jun 4, 2015 at 3:36 PM, Dr. Hawkins <doch...@gmail.com> wrote: > > > I have keys that get generated such as > > > > someKey_1 > > someKey_2 > > > > I just hit the snag that someKey_10 comes between the two of these. > > > > Is there a clean way to get SQLite (in memory) to ORDER these numerically > > without having to recode to force leading zeros? > > > > *yuk* > > > > -- > > Dr. Richard E. Hawkins, Esq. > > (702) 508-8462 > > _______________________________________________ > > use-livecode mailing list > > use-livecode@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
