Thank you..and actually it is a column that stores data as varchar and data is like this

start date

------------

20114 ----2011 is year and 4 is month

20113

20112

20105

20106

I need to represent above data as (adding date 01 to all rows)

2011401-- year month and date

2011301

2011201

2010501

2010601

that is I need to add date and convert into DATETIME and 101 style