Subject | NOT IN and NULLs |
---|---|
Author | Rick Debay |
Post date | 2005-10-07T18:08:26Z |
If a WHERE clause contains ACOL NOT IN ([VALUES]) and the data in ACOL
is NULL, what should be returned?
I'm always getting false for the statement if the column contains a
NULL, but if I don't have NULL as one of the IN values I should get back
true!
Thanks, Rick DeBay
is NULL, what should be returned?
I'm always getting false for the statement if the column contains a
NULL, but if I don't have NULL as one of the IN values I should get back
true!
Thanks, Rick DeBay