Sean wrote:
>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
>
>
This can ont be sorted unless you write your own operator and use it in
the ORDER BY clause.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Thu Sep 04 2003 - 00:17:11 CDT
