SQL function COALESCE

returns the first non-NULL value in the list (particularly useful for massaging NULL entries in columns resulting from OUTER JOINS)