ALTER PROCEDURE [dbo].[SearchCompaniesFiltered] 
	@Name nvarchar(100) = null,
	@ProductionTypes nvarchar(20) = null
AS
BEGIN

declare @ProductionTypesTable TABLE (
	ProductionTypeID int
)

IF @productionTypes is not null BEGIN
	set nocount on
	declare @separator char(1)
	select @separator = ','
	declare @separator_position int -- This is used to locate each separator character
	declare @array_value varchar(100) -- this holds each array value as it is returned

	set @ProductionTypes = @ProductionTypes + @separator
	while patindex('%' + @separator + '%' , @ProductionTypes) <> 0  -- Loop through the string searching for separtor characters
	begin
		select @separator_position =  patindex('%' + @separator + '%' , @ProductionTypes)   -- patindex matches the a pattern against a string
		select @array_value = left(@ProductionTypes, @separator_position - 1)
 		insert into @ProductionTypesTable (ProductionTypeID) values (@array_value)  
  		select @ProductionTypes = stuff(@ProductionTypes, 1, @separator_position, '')  -- This replaces what we just processed with and empty string
	end
	set nocount off

END



SELECT tblEntry.EntryID, EntryName , Town, County, Postcode
FROM tblEntry
INNER JOIN 
WHERE 
	(@Name is null OR CONTAINS(tblEntry.*, @Name)) -- name
AND 
	(@ProductionTypes is null OR
		or tblEntry.EntryID in (select EntryID from @ProductionTypesTable as types inner join tblEntryProductionTypes  on types.ProductionTypeID =tblEntryProductionTypes.ProductionTypeID)
	)
ORDER BY PaidEntry DESC, EntrySortName

END

declare @ProductionTypesTable TABLE
(
	ProductionTypeID int,
	PRIMARY KEY
	(
		ProductionTypeID
	)
)