[thelist] sorting question
JCanfield at magisnetworks.com
JCanfield at magisnetworks.com
Tue Feb 19 21:43:01 CST 2002
We're pulling some numbers from an MS-SQL db in the format 3.1, 3.2, . . .
3.9, 3.10, 3.11, 3.12 etc.
I need to sort them so that 3.2 comes before 3.12 (that is, three point two
comes before three point twelve.) They're accounting thingies, rather than
plain old decimals.
Is there a way to parse, sort, and concatenate within SQL? Any other ideas?
Thanks.
joel at spinhead.com
More information about the thelist
mailing list