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