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>
A1/10
A11/1
A1/11
A11/2
A1/12
A11/3
A1/13
A11/4
A1/14
A11/5
and so on
Can anyone help me?
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?
--Received on Sun Apr 08 2001 - 00:25:22 CEST
***********************************************
Peter Häusler luciver_at_teleweb.at Irren ist menschlich. Aber wenn man richtig Mist bauen will, braucht man einen Computer.
***********************************************