NullWhenNumeric

Table of Contents



Returns null when the number equals compareToValue, otherwise returns the number.

Numeric NullWhenNumeric(Numeric value, Numeric compareToValue)

round-pushpin Returns null and 5.
SELECT NullWhenNumeric(5, 5) as A, NullWhenNumeric(5, 6) as B FROM Single