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

From: G Colby <gcolby_at_waid.com>
Date: Wed, 31 Jan 2001 16:18:28 GMT
Message-ID: <oVWd6.77472$I9.5358696_at_news5.aus1.giganews.com>


Thanks, folks; a classic example of not thinking there. :)

I hadn't thought of doing it like that; actually, I wasn't familiar with that particular command.

Now, I'm a happy guy. I do appreciate the fast response time, too!!

Glen

Sammy Chan wrote in message <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
>
Received on Wed Jan 31 2001 - 17:18:28 CET

Original text of this message