>>I am converting a program from VFP to SQL with ado.
>>
>>I seems that the sql statements are not compatible.
>>The SUM with an IIF statement does not give the correct result
>>
>>Example
>>
>>select *, sum(uurfact) as fact, SUM(IIF(ureisk='Ja ',1,0)) as reisk from uren where umcode= '20002 ' group by umcode
>>
>>Can someone help me.
>>
>>Kind regards
>>
>>
>>Jan Dorresteijn
>
>IIF is a VFP command and not recognized by SQL Server.

OK but is there an other solution

Kind regards,

Jan