extracting data from a table

Folks

I have to extract data from a table in the HR database.

The columns in the table are Name, DOB, SS, STATUS and the data appears as such:

NAME              DOB               SS        STATUS
doe, john         01/01/77       11-11-1111      A

The data needs to be placed in the following format:

Last Name         First Name       Last 4 SS    Month    Year    Status
Doe                John              1111         01      77        A

The process needs to run every day.
How can I get these results?

Thanks in advance Received on Tue Jun 10 2003 - 08:57:01 CDT