Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Sorting alphanumeric column

Sorting alphanumeric column

From: <tammy_gutter_at_yahoo.com>
Date: 1 Jun 2005 17:50:07 -0700
Message-ID: <1117673407.535254.94100@g49g2000cwa.googlegroups.com>


Hi,

Is there a way to sort an alphanumeric column in this order? Basically, I want to ignore the alpha characters:

.2
.4

2

2.05
2.22
2.4
2.6

TA2.9
TB2.8
3.2
4.8
7.1

Thanks in advance. Received on Wed Jun 01 2005 - 19:50:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US