how to use like in sql server in varchar type query

USE [SCJ]
GO
/****** Object:  StoredProcedure [dbo].[spGetCHILD_outof state]    Script Date: 04/17/2014 03:16:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<author,,name>
-- Create date: <create>
-- Description:	<description,,>
-- =============================================

-- [spGetFilteredSchl] '12','01','101'

ALTER PROCEDURE [dbo].[spGetCHILD_outof state]
(
	@DistrictID varchar(250),
	@BlockID varchar(250),	
	@VillageID varchar(250)
)
AS
BEGIN	
	
	SET NOCOUNT ON;	
		
		DECLARE
	@ChildTblName AS VARCHAR (125), 
   
     @vQuery1 AS VARCHAR (max); 
    
    SET @ChildTblName = '[' + @DistrictID + 'Child_D' + ']'
    	
	  CREATE TABLE #childcount
    (
        
        schname nvarchar(30),
        total_child varchar(30) 
    );
	 SET @vQuery1='select B.schname as schname,COUNT(A.cname) as total_child from ' + @ChildTblName + ' A, 
               SCHMAST B where A.cname like '%11111' and  B.DCODE='+ @DistrictID +' AND B.BCODE='+ @BlockID +'and B.VCODE='+ @VillageID +'' 
	
   --insert into #childcount
   exec(@vQuery1)
  select * from  #childcount
     
    drop table #childcount;
	
	
	
END