>>>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.
Ooops. There was an implied aggregation in my head.