Re: SQL statement question...

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 Mon May 10 1999 - 21:32:00 CDT