Re: Column Sort

[David Donnelly <Dave@ISISBIO.COM>]

How about using the rpad function [of Oracle, that is -- I suppose other
databases have similar functions) to right-justify the text?


At 08:41 PM 10/8/1998 -0400, you wrote:
>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
>
>