Concatenation with NULL

Question

Accepted Answer

In SQL, concatenating anything with NULL using || produces NULL. NULL propagates through the expression. This trips up developers who expect NULL to behave like an empty string. Fix: use COALESCE to substitute a default - 'Hello' || COALESCE(NULL, '') || 'World' returns 'HelloWorld'.