BTW I just noticed you have an empty expression in between. It should error.
Cetin

>Thanks everyone!
>
>
>>>How do I do this in SQL?
>>>
>>>

>>>IIF(Trade.decTrade_Product_Balance <> 0 AND
>>>	(Trade.sTrade_Type_Pay_Rec = 'PAY' OR Trade.sTrade_Type_Pay_Rec AND Trade.sTran_Group_CD <> 'MAR'),
>>>		Transactions.decTrans_Amt, 0)
>>>

>>
>>

>>case
>>when Trade.decTrade_Product_Balance <> 0 AND
>>	(Trade.sTrade_Type_Pay_Rec = 'PAY' OR Trade.sTrade_Type_Pay_Rec AND Trade.sTran_Group_CD <> 'MAR') then
>>	Transactions.decTrans_Amt
>>else 0
>>end
>>

>>Cetin