Max field value

tobarich

I want to find the max value of a field in a table and I want to know if there is any function for this.
I don´t want to iterate through all the records of the table and ask if the value of the field is bigger than the value of the field from the record before.

Thanks

bbrown

Sort the records by that field and take the value of the first (or last) record.