Excellent, Thanks!
>See corrections below
>
>>The problem now is that SQL doesn't seem to like the 'AND' in the second CASE line.
>>
>CASE
> WHEN tr.sTrans_Type_CD ='PR' THEN tr.decTrans_Qty
> WHEN (tr.sTrans_Type_CD = 'PT' AND tr.decTrans_Qty > 0) THEN tr.decTrans_Qty
>> ELSE 0
>>END AS Receipt
>>
>>
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people