>>>I was just wondering if anyone knows of any prebuilt functions in VFP that will quickly search through a selected field in the table and find the record which has the highest value of that field? If not, I can always write my own, but I just thought I would check to see if there was already one that I have never run across yet.
>>
>>Does Select Max(fieldname) from table work for you?
>
>Sorry, that should have been select max(fieldname), recno() as recordno from table.

It's not going to work because RECNO() may not be from the record with max(fieldname).