Re: [SQL] ORDER BY case insensitive?

[Jeff Boes]

In article <PXEu7.602317$[EMAIL PROTECTED]>, "Bob
Swerdlow" <[EMAIL PROTECTED]> wrote:

> How do I get the rows sorted in a case insensitive way?

>      SELECT * FROM MyTable ORDER BY Name;

Try 

        SELECT * FROM MyTable ORDER BY upper(Name);

(or 'lower(Name)').

-- 
Jeff Boes                                             vox 616.226.9550
Database Engineer                                     fax 616.349.9076
Nexcerpt, Inc.                                      [EMAIL PROTECTED]

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly