KB-49201: Using Log10 function and Case/Else commands in an SQL query.

How can I have a Query’s Log10 function be executed only in rows different from 0 (zero), leaving rows equal to zero with value 0 (zero)?

Solution:

To apply Log10 function only to rows that are different from 0 (zero), you must use Case/Else commands inside an SQL query in order to test their values before you run the function. If the value is zero, the same value will be attributed to the field. If the value is different from zero, Log10 function will be applied.

Example of SQL query performing this:

NOTE: This code is only valid for SQLServer databases.