Re: numeric sorting on a char field having a decimal
Jaini schrieb:
> Hi,
>
> In Informix, I have a char(6) column in which decimals are stored. I
> need to sort in the numeric order. I have seen couple of query posted
> before which deals with numeric stored in a char field but I'm looking
> for decimals stored in the char.
>
> I need the o/p in following format -
>
> 10.1
> 10.2
> 10.3
> 10.10
> 10.22
> 10.29
> 10.4
>
> Thanks & Regards
> Abhinav
Try this:
select char_column
order by length(substr(char_column ,1,round(char_column))), char_column
Regards,
try_and_err