USE [Hugo]
GO

/****** Object:  StoredProcedure [dbo].[sp_with_Param]    Script Date: 16/02/2018 9:54:09 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE sp_Multi_LIKE_input_parameter
(@productNumberList nvarchar(max))
AS
BEGIN
  SET NOCOUNT ON
  DECLARE @Err int


    SELECT
      * FROM Bus2 p
       INNER JOIN ( SELECT SplitData FROM   dbo.udf_SplitString(@productNumberList, ',') ) a ON p.suburb LIKE a.SplitData+'%'
  END
GO