>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.
You can not use MIN/MAX function in SQL Select. You would need to use nested IIF and re-create the logic for MIN/MAX.
If it's not broken, fix it until it is.
My Blog