>>>Hi,
>>>
>>>Several of my reports use MAX(CHAR_FIELD) AS CHAR_FIELD when using GROUP BY clause. This, of course, to make sure that the GROUP BY does not "break" the report. My question is, is it wrong to have many MAX() for this purpose? Should I change the reports such as to minimize using MAX() around char type fields?
>>>
>>
>>A purist might say it's wrong. In practice the character field probably has the same value for all items in the group. I have done this myself without lying awake nights worrying about it.
>
>With Naomi's help I think I found a way to get rid of these MAX() all together. I am working on this now.

Take the rest of the day off, Dmitry ;-)

Actually I liked what you said the other day about the people who are willing to work harder being entitled to greater rewards. That probably wasn't exactly the way you said but I think it was the gist of it.