Processing When the divisor in SQL Server is "0"

Processing When the divisor in SQL Server is "0"

In SQL Server, when the divisor is 0, what should I do?
In such a situation, the version solved is that this operation cannot be executed, and the operation can be pre-determined before the division operation is executed. Here, we can use a case statement for judgment. If it is not suitable for calculation, we will do other things.

The Code is as follows:

1 case when construction area = 0 then null
2 when building area is null then null
3 when construction area <> 0 then approved payment amount/construction area end as unilateral cost

The building area here is the divisor. If it is 0 or null, you can perform your action as needed, that is, to change this null value to a field or something else, when the divisor building area is not 0, we can perform Division operations.