Problem for query in sql server

alter procedure [dbo].[generate_acno]
as
begin
	DECLARE @fnno varchar(2)
	DECLARE @cmpid VARCHAR(2)
	DECLARE @brid int
	DECLARE @scid varchar(2)
	DECLARE @Cusid int
    declare @accno varchar(6)
	declare @sql varchar(100)
	declare @slno int
	declare @StrCode varchar(8)
	set @fnno='01'
	set @cmpid='01'
	
	--SET @CNT=0
	DECLARE VoucherCursor CURSOR  
	FOR
	SELECT customer_id,Branch_id,cast(Scheme_id as varchar(2)) FROM t_customer_account order by customer_id
    OPEN VoucherCursor;
    FETCH NEXT FROM VoucherCursor INTO @Cusid,@brid,@scid;
	--update t_voucher_master set voucher_no=voucher_no+'*'
   WHILE @@FETCH_STATUS = 0
   BEGIN
	select @scid;
	if len(@brid)=1 
			set @StrCode=@fnno+@cmpid+'0'+cast(@brid as varchar(1))+@scid 
	else
		set @StrCode=@fnno+@cmpid+cast(@brid as varchar(1))+@scid 
	select @StrCode;
	   set @accno=(select +@StrCode+REPLICATE('0',6-LEN(CONVERT(INT,(isnull(max(substring(passbook_No,9,6)),'000000')))))+ CONVERT(VARCHAR,CONVERT(INT,(isnull(max(substring(passbook_No,9,6)),'000000'))+1)) from T_Customer_Account where passbook_No like +''''+@StrCode+'%'+'''');
       select @accno;
		--select ''' + @StrCode + ''' + REPLICATE('0',6-LEN(CONVERT(INT,(SUBSTRING(isnull(max(Account_No),'000001'),9,6)))+1)) + CONVERT(VARCHAR,CONVERT(INT,(SUBSTRING(isnull(max(Account_No),'000001'),9,6))+1)) from T_Customer_Account where Account_No like +''' + StrCode + ''%'' +''';
		--set @CNT=@CNT+1;
		--SET @VOUCHER_NO='Pv'+cast(@CNT as varchar);
		update t_customer_account set passbook_no=@accno where customer_id=@Cusid;
		FETCH NEXT FROM VoucherCursor INTO @Cusid,@brid,@scid;
   END;
end;
CLOSE VoucherCursor;
DEALLOCATE VoucherCursor;