NULLIF ( scalar_expression_1, scalar_expression_2 )
Syntax Elements
- scalar_expression_1
- The scalar expression to the left of the = in the expanded CASE expression:
CASE WHEN scalar_expression_1 = scalar_expression_2 THEN NULL ELSE scalar_expression_1 END
- scalar_expression_2
- The scalar expression to the right of the = in the expanded CASE expression:
CASE WHEN scalar_expression_1 = scalar_expression_2 THEN NULL ELSE scalar_expression_1 END