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

Congrats welcome to the world away from Microsoft, this is not SQL Server. Best bet is when inserting/updating columns that are searched upon regularly insert/update them with LOWER or UPPER (as you prefer) and use the same format within your applications to search against. If you do not do this even your indexes will be messed up!

HTH Will

"Sammy Chan" <chasersar_at_sinaman.com> wrote in message news:9597m8$q9q1_at_rain.i-cable.com...
> 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 Thu Feb 22 2001 - 23:07:05 CET