How do I sort alphabetically CASE INSENSITIVE???

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 - 14:41:39 CET