[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

Sorting substrings of different lengths numerically, part 2

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


More information about the thelist mailing list