That really is an excellent homework assignment.
"Sean" <aether8203_at_yahoo.com> wrote in message
news: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 Fri Sep 05 2003 - 14:42:01 CDT
