On Fri, Mar 12, 2010 at 11:00 AM, Luther, Ron <Ron.Luther at hp.com> wrote: > Select NVL(STEPSDEPARTMENT,SQUAWKSDEPARTMENT) as JW_Dept from ... > > HTH, > RonL. > > (These can also be nested.) Perfect! Thanks Ron. I owe ya a cold one for that. -jeremy