[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Column Sort
- Subject: Column Sort
- From: Charlie Dornbos <charlied@TIR.COM>
- Date: Thu, 8 Oct 1998 20:41:23 -0400
- Importance: Normal
Does anyone have any Ideas about sorting a Alpha-Numeric column so that
Numbers are sorted from least significant to Most (Right to Left). If the
column was all numbers, I know I could use to_number(PMNUM), but this fails
when the column contains any text. I get complaints from users who
understandably don't like to see lists like:
10
100
1000
11
111
Any thoughts? I am using SQR3.5 with Maximo 3.02 and Oracle 7.2 Tanks,
charlied@tir.com