ORDER BY UPPER(somefield) will do what you are wanting.
-Dan
----- Original Message -----
From: "Uro Gruber" <uros(at)sir-mag(dot)com>
To: <pgsql-general(at)postgresql(dot)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š
>
>