>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

Though it's a bit unclear about ( OR AND) in the second (). What is the condition in English?