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

did you try ... ORDER BY NLS_LOWER(colors)

Just a thought, don't know if it works.

JB

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 Wed Jan 31 2001 - 16:20:42 CET