some RDBMS (such as MS SQL Server) allow you to specify a collation scheme on your database, tables or even columns within a table that will cause an ORDER BY to be done in a case-insensitive fashion by default. If you have such an RDBMS it is probably most efficient to use this facility.

/J\