SQL Case compare null value against null to equal a pass

case when a = b or (a is null and b is null)
then 'pass'
else
'failed'
end

1 Like