Need to add two database fields together if result is zero 1

[ITmfgCO]

I am createing a database view and need to have a case statement when the Unit Price field is equal to zero, I want to add the material cost and burden cost and return it to the unit price field.

esetially, IIf([dbo_CUST_order_line.unit_price]=0,[dbo_Part.UNIT_MATERIAL_COST]+[dbo_Part.UNIT_BURDEN_COST],[dbo_CUST_order_line.unit_price]) AS price

however I can not get this to work in SQL Qery Analyser....

 

[bborissov]

There is no IIF() function in TSQL

esetially, 
 CASE WHEN [dbo_CUST_order_line.unit_price]=0
      THEN [dbo_Part.UNIT_MATERIAL_COST]+
           [dbo_Part.UNIT_BURDEN_COST]
 ELSE [dbo_CUST_order_line.unit_price] END AS price

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[ITmfgCO]

Awesome, that worked great!

thank you!