Expressions that Evaluate to NULL

An expression with an arithmetic or bitwise operator evaluates to NULL if any of the operands is null.

For example, this evaluates to NULL if column1 is NULL:
1 + column1