>>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, ...)

Don't think that's what he wants. I think in each record, he wants one field that contains the minimum of those field for that record.

Tamar