In Oracle, function NVL provides a conversion of NULL values to non-null values:
NVL(TO_CHAR(MANAGER_ID),'No Manager')
converts all of the NULL values in the manager_id column to the string: "No Manager"
In DB2, use the COALESCE function to convert nulls, as in:
COALESCE(MANAGER_ID,'No Manager')