Re: order by question

Hi Frank,

try this: select t from x order by substr(t,1,1),substr(t,2,1); It will do the trick, but is highly specialized to your problem.

cu
Andy

Frank Streitzig schrieb:

> Hi,
>
> i have a order by question. I have a table x with one column t char(5). The
> table contain 6 rows.
>
> #1
> 1)
> #2
> 2)
> #3
> 3)
>
> I like sort table (select t from x order by t), but receive no order.
> I like follow sorting:
>
> #1
> #2
> #3
> 1)
> 2)
> 3)
>
> Can anybody help me?
>
> Sorry for my language. :-)
>
> Frank Streitzig
> Germany
Received on Mon Dec 13 1999 - 09:34:29 CST