Another way of representing Case when Expression1 = Expression2 Then NULL Else Expression1 End It is important to be aware that non-deterministic functions may have an impact since it evaluates two times and returns different values. Eg. NEWID(), RAND() etc. I’d like to grow my readership. If you enjoyed this blog post, please share it with your friends!