date time formatting

Hi,

create table #TempTable
(
    mdate varchar(30)
)

insert into  #TempTable values ('20101211124624')
insert into  #TempTable values  ('20101211124625')
insert into  #TempTable values ('20101211124626')
select * from #TempTable
select cast(substring(mdate,1,8) + ' ' + substring(mdate,9,2) + ':'+ substring(mdate,11,2) +':'+  substring(mdate,13,2) as datetime) 
from #TempTable

Best Regards.