No, I am afraid there is no such a function :o(((. MAX() gives You the MAX() from the entyre table (or GROUP) (at least in SQL Server and VFP).
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.