Hi
Try the following way....
DECLARE @SNo VARCHAR(30)='ECR12345432123456543216', @NextSNo VARCHAR(30)=''
SELECT @NextSNo='ECR'+RIGHT('00000000000000000000'+CAST(CAST(SUBSTRING(@SNo,4, 20) AS numeric(20,0))+1 AS VARCHAR(20)),20)
SELECT @SNo 'SNo', @NextSNo 'NextSNo'
Regards,
GVPrabu