I've possibly forgotten something trivial or learned something new today...

How, in an sql statement, do you get the min value of, say, 5 values?

I try something like SELECT MIN(field1,field2,field3,field4) FROM MYFILE

and VFP wants to assume MIN() is aggregation of several rows....

Thanks in advance.