Friday, September 20, 2013

Divide by zero SQL-server- NULLIF

Select qty/ NULLIF((select amt from amtfile where itemno=123),0) from itemqty


or user case when (select amt from amtfile where itemno=123) =0 then Null else select amt from amtfile where itemno=123) =0 end



No comments: