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