How to Numerically Order varchar2 Column

From: Freedom <luciver_at_teleweb.at>
Date: Sat, 07 Apr 2001 22:25:22 GMT
Message-ID: <mtMz6.106274$cj.4421144_at_news.chello.at>


[Quoted] I have a Table with following Data

A10/1
A10/22
A10/3
A10/4

A1/10
A11/1
A1/11
A11/2
A1/12
A11/3
A1/13
A11/4
A1/14
A11/5

and I would like to sort this corectly like a number type

A1/9
A1/8
A1/7
A1/6
A1/5
A1/4
A1/3
A1/2
A1/1
B1/9
B1/8

and so on
Can anyone help me?
--

***********************************************
Peter Häusler luciver_at_teleweb.at Irren ist menschlich. Aber wenn man richtig Mist bauen will, braucht man einen Computer.
***********************************************
Received on Sun Apr 08 2001 - 00:25:22 CEST

Original text of this message