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@opensubsystems.org> wrote in message
news:559596967.20050510114150@opensubsystems.org...
> 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@opensubsystems.org
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
