[thelist] 1.1.2 Sorting

rudy r937 at interlog.com
Thu Dec 5 14:53:00 CST 2002


> Your only hope is to parse it on the periods, sort each field
> left to right, then rebuild the strings.

and that's a real pain, if all you have to work with is sql's SUBSTRING and
POSITION functions

here's what it looks like using microsoft access (caution: not for the faint
of heart) --

Sorting substrings of different lengths numerically
http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid
473817_tax285649,00.html

Sorting substrings of different lengths numerically, part 2
http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid
473819_tax285649,00.html


i'm sure there must be a better approach, like a user-defined function where
you can use looping...


rudy




More information about the thelist mailing list