NullWhen

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

String NullWhen(String value, String compareToValue)

Returns null and 'x'.

SELECT NullWhen('x', 'x') as A, NullWhen('x', 'y') as B FROM Single

• Scalar Functions