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