Converting strings to DATE in SQL Server

i have an old database that I'm converting from Access to MS SQL Server 2008. In the Access database, dates were written as 02/2008 so MM/YYYY. I want to convert this to a DATE type, where I can show something like MM/DD/YYYY. Is there any way to 开发者_如何学Godo that using SQL Server? When I tried CONVERT, it fails beacuse there are some irregular dates, such a

• 1/2008
• 01/2004
• /2001
• /4
• etc

so my thought is that I will just write up some code to go through each date and use regex to convert it, and then save it back to the database in a new table.

Any thoughts on how to make this easier?

Looks like your only choice here is some sort of string manipulation like you've proposed. What part of the process would you like to make easier?