Viewing 6 posts - 1 through 7 (of 7 total)
AndyK-565224 (3/28/2014)
"Hello" = NULL does not result in a FALSE - it results in NULL.likewise NOT(NULL) is neither TRUE nor FALSE, it is NULL
Why is this desirable? How...
March 28, 2014 at 10:45 pm
I am going to try to pose this (same) question one more time. This is a simple question about the value of something that makes no sense to me....
March 28, 2014 at 7:18 pm
I appreciate the replies. I understand the explanation. What I do not understand is why and/or how it would be useful to have the result of comparing something...
March 27, 2014 at 6:14 pm
I know that. I also know (ok, I think I know) that an actual string literal is not null. It is not the absence of a value because...
March 27, 2014 at 6:10 pm
When and why would it be useful to have ANSI_NULLS on?? Something is either null or it isn't to me. Having the system say "I can't tell you...
March 27, 2014 at 11:57 am
I get the explanation for why 5 does not show up. Is that the same reason 2 also doesn't show up? My guess was 2, 4, and 5.
March 26, 2014 at 10:34 pm
Viewing 6 posts - 1 through 7 (of 7 total)