Re: ORDER BY options (how to order data as AAA, aaa, BBB, bbb, ... ZZZ, zzz)

if you order by upper(name) then it will mix them all together, so you won't
have capital before lowercase, but it will put all the lowercase a before
the uppercase b

"Julian Legeny" <julo(at)opensubsystems(dot)org> wrote in message
news:559596967(dot)20050510114150(at)opensubsystems(dot)org(dot)(dot)(dot)
> Hello,
>
> I have following problem:
>
> I have table MY_TABLE with following records:
>
> NAME
> -----------
> ccc
> CCC
> AAA
> aaa
> bbb
> BBB
>
> When I use default select that sort all data by NAME:
>
> SELECT * FROM MY_TABLE ORDER BY NAME;
>
> result is following:
>
> NAME
> -----------
> AAA
> BBB
> CCC
> aaa
> bbb
> ccc
>
>
> But I would like to sort all data as following:
>
> NAME
> -----------
> AAA
> aaa
> BBB
> bbb
> CCC
> ccc
>
>
> How can I write sql command (or set up ORDER BY options) for selecting
that?
>
>
> Thank you in advance for answer,
> best regards,
>
> Julian Legeny
>
> mailto:julo(at)opensubsystems(dot)org
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>