>Hi George
>
>I may be wrong, but Max() doesn't guarantee you get the last row, merely the highest value in that column in that group. Isn't this like comparing apples to oranges ;) ?
Mike,
You're not wrong. MAX() should return the largest value. If there's a group by including the field, then it'll be the largest value for that group. If not, then it'll be the largest field value regardless. AFAIK, there's no SQL statement that, under these circumstances, is guaranteed to return the value of the last physical record.
George
Ubi caritas et amor, deus ibi est