Find the max value of a field

last()

Leo

@Leonid... Last will give you last record in the set... so you need to combine that with an order by clause.. and to account for mixed ASCII sorting where lower case letters sort AFTER upper case.. you may want to convert them all to the same case .. if your search is to be case insensivity.. 

Assume you have a People table.. .andt there is a column called 'Last Name' .. to find the greatest value of last name.. case insensitive... 

let p:= last((select People) order by upper('Last Name'));
p.'Last Name'

That's right, I should have explained that before.