SQL script to modify data

CLOSED
Bids
64
Avg Bid (USD)
$44
Project Budget (USD)
$30 - $250

Project Description:
I have a MSSQL 2008 R2 server that has a table I need someone to write a SQL query that will split an address field containing "ST. Peters MO 63132" into "St. Peters", and "MO", and "63132". Zip is constantly last 5 chars. Starting at the end of the field value splitting by space. Convert it to City, State, Zip fields.

In same Query. Convert Thursday 05/23/2013 to MMDDYYYY

In same Query, select a employee code via a JOIN on an employee table by Emp_Name = Emp_Name

This should only take the right person about 1 hour.\

Skills required:
Database Administration, SQL
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 33
in 0 days
Hire thanhlongfree
$ 39
in 3 days
Hire feninsoftech
$ 55
in 3 days
$ 35
in 1 days
$ 66
in 1 days
$ 49
in 0 days
$ 55
in 1 days
$ 39
in 1 days
$ 35
in 1 days
Hire zafoxyfox
$ 35
in 1 days