NullIfNumeric

Returns null when the conditional is true, otherwise returns the number.

Numeric NullIfNumeric(Numeric value, Boolean conditional)

Returns 10 because the condition is false.

SELECT NullIfNumeric(10, IsEqual('Test', 'Other')) as Result FROM Single

• Scalar Functions