Re: Sorting alphanumeric column

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 02 Jun 2005 08:35:57 -0700
Message-ID: <1117726430.459007@yasure>

Paul wrote:
>
> DA Morgan <damorgan_at_psoug.org> wrote:
>
>
>

>>You got 2.8 before 2.9 which was my stopping point. It is easy if
>>that is the correct answer but the OP indicated it was not.

>
>
>
> I strongly suspect that putting 2.9 before 2.8 was a typo on the part
> of the OP.
>
>
> Paul...

If you are correct then:

ORDER BY TO_NUMBER(TRANSLATE(column_name, '1ABT', '1')) solves the problem.

My guess is that TA must come before TB so that TB9.9 would preceed TA1.0. Lets see if the OP will clarify the matter.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Thu Jun 02 2005 - 10:35:57 CDT