[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