Take the 2-minute tour ×

IF @IS_EMAIL = '1' .....

IF (ISNULL(@IS_EMAIL , '0') = '1') .....

Will those 2 condition resolve to the same result for every value of @IS_EMAIL?

share|improve this question
Yes. Both IF's will only execute when the value is '1'. In the second IF the value null is mapped to '0' first. But zero is irrelevant for the IF to pass –  Hazaart Jun 13 '13 at 12:06

2 Answers 2

up vote 0 down vote accepted

Yes, they will work the same.

Second one will evaluate to if 0 = 1 when @IS_EMAIL is null.

share|improve this answer

Yes. But consider the first one as it's easier to understand and it should be faster.

share|improve this answer

Your Answer


