several ways to approach that, without it being built in as an expression.
as a string: order_by=["name COLLATE NOCASE"] or just using the lower() function (to me this would be more obvious) order_by=[func.lower(table.c.name)] or you could use sql's _CompoundClause: from sqlalchemy.sql import _CompoundClause order_by = [_CompoundClause(None, table.c.name, "COLLATE NOCASE")] Id go with func.lower() probably... --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---