[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