SQL script to modify data

This project received 64 bids from talented freelancers with an average bid price of $44 USD.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Total Bids
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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online