Calculated column does not work in SQL Server 1

[pss08]

I have a simple SQL Select command with a calculated column that it is working for years in an Access database. Now passing this same Select to SQL Server does not work.

SELECT Invoice.Date,Invoice.Name,Invoice.Total,.....

and this is the calculated column:

(Invoice.Paid + Invoice.TotalTax * Abs(Invoice.Paid > 0) * Abs(Invoice.PayType <> 'EFP'))"

Explanation: Invoice.TotalTax allways has some positive value, but Invoice.TotalTax must be changed to 0 if Invoice.Paid is 0, or if Invoice.PayType is 'EFP'

Any help to solve this in SQL Server.

 

[bborissov]

(Invoice.Paid + Invoice.TotalTax * 
 CASE WHEN Invoice.Paid <= 0 OR Invoice.PayType = 'EFP' THEN 0
      ELSE 1 END)

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.