There was an error processing your information. To return a 0 value instead of a NULL value, you can put the division operation inside an ISNULL function: SET ARITHABORT OFF SET ANSI_WARNINGS OFF SELECT ISNULL([Numerator] / [Denominator], 0) But this,time, let's provide a default value if the division isnot valid.--->
All Rights Reserved. I find this to be much more straight forward and readable. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Your solution with nullif() is the correct one.