Michael Bayer wrote: > The basic request to get cities as strings by themselves should be > easy enough as: > > select([Customer.city]).distinct().order_by( > Customer.city).execute().fetchall()
That's exactly what I wanted - and yes, that's really easy. > we will eventually have a database-neutral "ilike" comparator but that > hasn't been implemented yet. Ok, I'll use the approach with func.lower().like("a%") until then. I noticed func.lower().startswith("a") is also possible, a bit nicer. Thanks a lot for your quick support! -- Chris --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---