> > # How do I apply the lower(field) function to the strName column? > > rows = model.data.query().order_by(strName).all( > > query.order_by(func.lower(strName))
Thanks Michael - you're a life saver! Somehow, I seemed to have missed the entire section on sqlalchemy.sql.func. For anybody else in the same boat, here's the link in the documentation for it: http://www.sqlalchemy.org/docs/04/sqlexpression.html#sql_everythingelse_functions -Eric --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
