Re: How do I sort alphabetically CASE INSENSITIVE???

It is not a dumb question, you may be not familiar with SQL.

the SQL is :
SELECT Color FROM Colors ORDER BY UPPER(COLOR);

Regards,
Sammy

G Colby <gcolby_at_waid.com> wrote in message news:nCUd6.75742$I9.5295859_at_news5.aus1.giganews.com...
> 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 Wed Jan 31 2001 - 15:41:32 CET