This task can be done using a programming language like perl (DBI).
"rishi" <richadha_at_hipusa.com> wrote in message
news:d1741a2f.0306100557.7c556527_at_posting.google.com...
> 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 Wed Jun 11 2003 - 02:14:16 CDT
