Along the same lines as @Eric’s answer, but without using a 'NULL' symbol.
(Field1 = Field2) OR (ISNULL(Field1, Field2) IS NULL)
This will be true only if both values are non-NULL, and equal each other, or both values are NULL
Along the same lines as @Eric’s answer, but without using a 'NULL' symbol.
(Field1 = Field2) OR (ISNULL(Field1, Field2) IS NULL)
This will be true only if both values are non-NULL, and equal each other, or both values are NULL