The following statement is in my VFP code for SPT Query:

SqlSelect =
"Select Sum(IIf(ArAudit.AUlAdjRec, 0.0000 ,ArAudit.AUyAmt)) As Receipts,
Sum(IIf(ArAudit.AUlAdjRec, ArAudit.AUyAmt, 0.0000)) As Adjtmnts

From ArAudit Inner Join ArCharge Inner Join LookUp On ArCharge.CHilookUp = Lookup.lOiID On ArAudit.AuiCharge = ArCharge.ChiId

Group By AUiCharge"

How can I convert these 'Sum(IIf ...)' statements to T-SQL for SQL Server 7 so that it will also work in VFP?

TIA,

Ed