check this
Create table #file(col1 varchar(20))
insert into #file select 'MBA00001'
insert into #file select 'MBA00002'
insert into #file select 'MBA004042'
insert into #file select 'MBA00500'
select 'MBA'+Convert(Varchar(20),MAX(convert(int,REPLACE(col1,'MBA','')))) from #file