I am hunting around for a way to grab the most recent transaction date for a certain doc type on the cardex file... The only way I can think of to do it right now is to perform a select -- fetch next with a do while. That would work, but would just destroy the processing. In SQL I would perform a select max(iltrdj) but that's about all I can think of right now. Is there a way to select max of a certain field given a doc type?