• You really are doing too much. You can create a computed column using the convert part shown below, just replace the variable @TestDate with your column name :

    declare @TestDate varchar(10) = '01/2013';

    select @TestDate, convert(datetime, stuff(@TestDate,3,0,'/01'), 101);