Jeremy Weiss asked about the Oracle NVL command. >>The department will always be STEPSDEPARTMENT unless it's null, then it's SQUAWKSDEPARTMENT. Select NVL(STEPSDEPARTMENT,SQUAWKSDEPARTMENT) as JW_Dept from ... HTH, RonL. (These can also be nested.)