On 10/10/06, Oleg Broytmann <phd@phd.pp.ru> wrote:
from sqlobject.sqlbuilder import func
print list(Songs.select(orderBy=func.lower(Songs.q.name)))
   Does it help?

Oleg.


Yes that works fine, thanks for the fast response! I was reluctant to delve into sqlbuilder- but that does not look too bad.

Thanks,
Luke