Re: Alphanumeric Sort

From: ÃÖ»ó¼ø <topgun_at_freeway.co.kr>
Date: Tue, 24 Aug 1999 06:41:59 GMT
Message-ID: <X8rw3.1213$T9.66850@news.bora.net>

johnp_at_1rent.com ÀÌ(°¡) <7pt94a$aij$1_at_nnrp1.deja.com> ¸Þ½ÃÁö¿¡¼ ÀÛ¼ºÇÏ¿´½À´Ï´Ù...
>Oracle Gurus,
>
>I am trying to sort on an alphanumeric column. The default order is:
>
>1
>100
>11
>2
>23
>7
>A1
>A100
>A2
>B2
>
>The desired order is:
>
>1
>2
>7
>11
>23
>100
>A1
>A2
>A100
>B2
>
>Any suggestions?
>
>Thanks!!!
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

order by to_number(ordering_data)

select orgadering_data,

          to_number(ordering_data) orgdering_data2 ,
          ..........
          .....
          ......

from

order by 2 ; Received on Tue Aug 24 1999 - 01:41:59 CDT