[yellowapple]

> which you probably _shouldn't_ be grouping on anyway.

This is frequently unavoidable, though. Or more precisely: it could be avoided with a sane database design, but the databases on which I have to work for my day job are the precise opposite of "well-designed", so grouping on complex expressions is unfortunately an inevitability.

[commandlinefan]

That's true - I can definitely imagine having to group on something like "concat(lastname + ', ' + firstname)".