The non-field items in the group by are the problem (DTOS(), etc.)...they need to be fields...

>Thanks for the info, but you will note that all of the non-aggregate clauses are included in the group by clause and it doesn't work even when I SET ENGINEBEHAVIOR 70 so I don't think that's it.