Joining name columns with a space

Question

Accepted Answer

|| is the standard SQL concatenation operator. It joins the three strings: 'Alice', ' ', 'Smith' into 'Alice Smith'. MySQL uses CONCAT(first_name, ' ', last_name) instead of ||. PostgreSQL supports both. Note: if either side is NULL, || returns NULL. Use COALESCE to handle NULLs: COALESCE(first_name, '') || ' ' || COALESCE(last_name, '').