Hi Edward,

You are not going to get the same exact code to work on both databases. I don't know what the datatype for your local logical field is, but I'll assume its a bit. For T-SQL, try:

SELECT 'receipts'=CASE 
   WHEN auladjrec=1 THEN 0
   ELSE SUM(auyamt)
   END
   'adjtmnts'=CASE
   WHEN auladjrec=1 THEN SUM(auyamt)
   ELSE 0
   END
   FROM araudit ....

...etcetera.........




>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