Jeff,

That did it!  I sincerely thank you for your help.

- John

Trigger,

Thanks for your assistance.  Your SQL helped greatly.  Now to expand on the original question.  What if my table is set up as follows:

DEPT_ID     DEPT_NAME          DATE_STAMP      TIME_STAMP

---------------------------------------------------------

11450      ...