From: Bruce Hart <B.A.Hart_at_bham.ac.uk>
Date: Thu, 01 Feb 2001 14:04:09 +0000
Message-ID: <3A796CD9.6756289E_at_bham.ac.uk>
Date: Thu, 01 Feb 2001 14:04:09 +0000
Message-ID: <3A796CD9.6756289E_at_bham.ac.uk>
Glen,
Doing "SELECT Color FROM Colors ORDER BY UPPER(COLOR)" should do what you want.
G Colby wrote:
> Okay, this is surely the dumbest question I have had to ask in quite some
> time....
>
> Assuming I have a table COLORS with the following values in the Color field:
>
> Red
> blue
> Green
> Yellow
> white
>
> If I issue "SELECT Color FROM Colors ORDER BY COLOR" I get the following
> list:
>
> Green
> Red
> Yellow
> blue
> white
>
> All the frikkin' uppercase names come before the lower case names. Is there
> ANY way to get around this? Is this a setting on my server, and if so, where
> do I make it?
>
> I'm running 8.05i, to the best of my knowledge.
>
> Thanks,
> Glen
Received on Thu Feb 01 2001 - 15:04:09 CET