Re: What query can sort this?

From: Chunyu Hu <hu_chunyu_at_eachnet.com>
Date: Thu, 4 Sep 2003 13:08:24 +0800
Message-ID: <bj6hbp$1o3k$1@mail.cn99.com>

maybe u can split the column into number columns, col1,col2,col3,... and then order by col1,col2,col3...
I don't have time to write the sql statement, but I expect it'll be very complex, and you need functions like instr,substr,decode.

regards,

HuCY
"Sean" <aether8203_at_yahoo.com>
??????:9f0ea455.0309031737.5028d39a_at_posting.google.com...
> I have been trying to sort on a column of data and am stumped. Does
> anyone have any advice?
>
> The column is a VARCHAR2(15)
>
> Footnote_no
> ------------
> 1
> 1.1
> 1.2
> 1.2.1
> 1.2.2
> 1.2.2.1
> 1.4
> 1.6
> 1.10
> 1.11
> 1.12
> 1.12.1
> 1.12.1.1
>
> etc.
>
> As you can tell from the data above, it is already in a nice ascending
> order and is the ultimate result I am looking for. By just applying a
> sort you get
>
> 1.10
> 1.11
> 1.12
> 1
> etc...
>
> I think you get the idea.
>
> Any suggestions?
> Thanks,
> Sean
Received on Thu Sep 04 2003 - 00:08:24 CDT