How To Pick Alphabet In A String

I need to increment values

I have written this script execute this :

This is for this scenario

Insert Into #String SELECT 'S601-S630',1,'Desc1'
Drop table #IDs
CREATE TABLE #IDs(ID INT IDENTITY(1,1) ,String VARCHAR(100),Flag Int,Description VARCHAR(1000))
CREATE TABLE #string(ID INT IDENTITY(1,1) ,String VARCHAR(100),Falg Int,Descript VARCHAR(1000))
DECLARE @min INT ,@Max INT ,@String VARCHAR(50),@Start VARCHAR(50),@End VARCHAR(50),@Flag INT,@Desc VARCHAR(1000)

[Code] ....

How I need to increment if the input is like this

Insert Into #String SELECT '6S01-6S30',1,'Desc1'

if alphabet is in middle of the number??