Thanks
>In VFP you'll have to use IIF() or ICASE(). No compatibility, I'm afraid.
>
>> Would the following TSQL work in VFP:-
>>
>>SUM(case when invh.invdate between lcMonStart AND lcMonEnd then gross else 0 end) as MTDAmount
>>
>>if not is SUM(IIF ....) the only way out, I am looking for something that is VFP and MSSQL compatible.
Regards N Mc Donald