Thread: Re: ORDER BY case insensitive?

In article <PXEu7.602317$T97.80972819@typhoon.nyroc.rr.com>, "Bob
Swerdlow" <swerdlow@maine.rr.com> 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.                                      jboes@nexcerpt.com