>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....
Why not
select min(field1) as min1, min(field2) as field2 ...
lnMin=min(min1, min1, ...)