• I understand the True, False, Unknown of Null evaluations. However, It's not UNKOWN to me.

    1. Will I receive results from the query? -- FALSE
    2. Did the question specify "ANSI NULLS = ON"? -- FALSE
    3. How does the predicate "Myid = NULL" evaluate? -- UNKNOWN
    4. How does the WHERE clause evaluate? -- (I still say FALSE)
    5. Does everyone get fired up about this? -- TRUE
    6. Will I get my points back? -- UNKNOWN to me (Only Steve Knows)
    7. Will I get over it? -- TRUE