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
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people