ORDER BY UPPER(somefield) will do what you are wanting.
-Dan
----- Original Message -----
From: "Uro Gruber" <uros@sir-mag.com>
To: <pgsql-general@postgresql.org>
Sent: Friday, January 12, 2001 4:06 PM
Subject: [GENERAL] ORDER BY works stranke
> Hi!
>
> I noticed that order by works strange
>
> if i use ORDER BY some field i get result like this
>
> Mytest
> Test
> arethistest
>
> But it supposed to be
>
> arethistest
> Mytest
> Test
>
>
> Is it possible to reorder this alphabetical but not to use caps.
>
> thanks
>
> --
> Uroš
>
>