How do I get the rows sorted in a case insensitive way?
I have some queries that basically fit the form:
SELECT * FROM MyTable ORDER BY Name;
When I view the results, all of the Name's that start with an upper case
letter precede all of the Name's that start with a lower case letter. I
want them all in alphabetic order, regardless of case.
I've looked in PostgreSQL Introduction and Concepts by Bruce Momjian and in
the FAQ at http://postgresql.overtone.org/docs/faq-english.html
Thanks for your help.
--
Bob Swerdlow
Chief Operating Officer
Transpose, LLC
rswerdlow(at)transpose(dot)com