Pass a number of terms seperated by commas into COALESCE() and it will return the first non-null value. The most common thing that I've seen goes like this:
SELECT key, COALESCE(datum1, 0), COALESCE(datum2, 0) FROM table
or
SELECT lName, fName, COALESCE(midIn, "") FROM table...