Re: SQL statement question...

From: <shiling_at_math.wayne.edu>
Date: Tue, 11 May 1999 02:32:00 GMT
Message-ID: <7h84r0$1rv$1_at_nnrp1.deja.com>


[Quoted] Are you sure A is not CHAR?

In article <37383FFD.219D56F0_at_comp.polyu.edu.hk>,   Jimmy <c6635500_at_comp.polyu.edu.hk> wrote:
> Hello all,
> I have a table with column A of number data type.
> I want to select column A and convert A values to char type as
> follows:
>
> select to_char(A) from table order by A
>
> However, I find that the column A cannot display in order. This is
> because after the function to_char, the order is in character, not in
> number. So I get the following results:
>
> 1,11,12,2,22,23 ... not 1,2,11,22,23...
>
> How can I get the above results (order by A numeric value and
> convert to character data type) by using a single SQL statement?
>
> Thanks,
> Jimmy
>
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 11 1999 - 04:32:00 CEST

Original text of this message