Cetin

>>>select max(max(nField, 99*1)) as Column1 from myTable
>>Are you sure this one will work?
>>
>>>Note that in last sample outer max is SQL aggreagation function whilst inner max is VFP's max() function.
>>Inner one won't work!

>John,
>Did you try the sample ? Inner one works as arithmetiuc max.
>Cetin

Correction! It works - but what exactly is it for? I _still_ want my arithmetic MAX().

Waaah!

John Burton