12

WHERE CASE WHEN field1 IS NOT NULL THEN ISNULL(field1,NULL) END = ISNULL(field2,NULL)

So many wrongs, my wrong-o-meter broke...

Comments
  • 1
    My brain hurts reading that.
  • 0
    This must be the result of some serious overthinking.

    Can be reduced to:

    WHERE field1 = field2
Add Comment