sorting SQLite keys where no leading zeros at end of name
pete at lcsql.com
Thu Jun 4 19:07:28 EDT 2015
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.
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
On Thu, Jun 4, 2015 at 3:36 PM, Dr. Hawkins <dochawk at gmail.com> wrote:
> I have keys that get generated such as
> 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?
> Dr. Richard E. Hawkins, Esq.
> (702) 508-8462
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
More information about the Use-livecode