Explain three different rules that apply to NULLs when doing comparisons?

Answer 1

1. For all operators except for concatenation (||), if a value in an expression
   is a NULL, that expression evaluates to NULL

2. NULL is never equal or not equal to another value

3. NULL is never TRUE or FALSE