latingntlman (4/30/2013)
I just tried your suggestion as:update table
set MoYear = convert(datetime, stuff(MoYear,3,0,'/01'), 101)
When I select the table the values are displaying as Dec 1 2012 12:00AM; Aug 1 2012 12:00AM, etc.
No, you are trying to update a varchar column when I said you could add a computed column to your table using the convert statement to convert the value in MoYear to a datetime value.