like operator in sql server

ALTER PROCEDURE [dbo].[sp_GetCustomer] --'343'

            -- Add the parameters for the stored procedure here

    @CustomerID NVARCHAR(50)

AS

BEGIN

            -- SET NOCOUNT ON added to prevent extra result sets from

            -- interfering with SELECT statements.

            SET NOCOUNT ON;

    -- Insert statements for procedure here

            SELECT  CUST.CustomerID,

                                    CUST.CustomerName                                

              FROM [DBO].[CUSTOMER] as CUST WHERE CUST.CustomerID LIKE '%'+ @CustomerID +'%' 

END