Multiple choice technology

ISNULL returns FALSE for 0 value?

  1. TRUE

  2. FALSE

  3. MAY BE

  4. None of these
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

ISNULL returns FALSE for 0 because 0 is a valid numeric value, not NULL. NULL represents absence of value, while 0 is a definite number. This distinction is crucial in SQL - NULL != 0, and comparisons behave differently (NULL propagates in expressions).

Keep practicing — related questions