The short answer
Usually:
10 + NULLproduces:
NULLbecause the result is unknown.
Similarly, string concatenation involving NULL is dialect-dependent. Some systems propagate NULL, while others/functions may treat it differently.
For portable logic, explicitly handle it:
COALESCE(name, '')