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

Quick answer:

SELECT color FROM colors ORDER BY LOWER(color);

I believe it can can be done with Language settings etc, but this will do.

G Colby wrote in message ...
>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:23:50 CET