How to Split String in sqlserver?

hi,

very long but try....
select 'BE/CSE' + RIGHT('0000' + CAST(Cast(substring('BE/CSE01',7, LEN('BE/CSE01') - 5) as int) + 1 as varchar(10)),2)

also read my article

http://www.c-sharpcorner.com/UploadFile/ff2f08/auto-incremented-column-with-varchar-and-nvarchar-data-type/

hope this will help you.

CREATE TABLE dbo.YourTable
        (ID INT IDENTITY(1,1),
        YourColumn AS 'BE/CSE' + CAST(ID AS VARCHAR(10)) PERSISTED,
        ......
        )