Hmm it looks like I was thinking in human logic and not in "sql logic" .....it looks like I would have needed to use:

SELECT FROM Table Where Col <> 2 OR Col IS NULL

NULL = Unknown seems strange to me, I would have expected NULL to means "nothing" rather than "missing" or "unknown"


Thanks for that link, it was really specific to my question....did you just find that or do you have it bookmarked?