declare @tab table( BatchCode varchar(100))
insert into @tab
SELECT 'PSF/180' union all
SELECT 'PSF/B180' union all
SELECT 'ERS/B366' union all
SELECT 'ARPA/B146' union all
SELECT 'EFA/B989' union all
SELECT 'PSSR/B1096' union all
SELECT 'RECP/B175' union all
SELECT 'CHEMCO/B73' union all
SELECT 'ERS/B367'
select BatchCode
,LEFT(Batchcode, patindex('%[0-9]%',BatchCode)-1)+ CAST(cast(SUBSTRING(BatchCode, patindex('%[0-9]%',BatchCode), len( BatchCode)) as int) +1 as varchar(50)) NextBatchSeries
from @tab