SELECT [Name],
           [Color],
           [ListPrice],
           [ModifiedDate]
      FROM [Production].[Product]
     WHERE [Name] LIKE coalesce(@Name, [Name])
       AND Colour] LIKE coalesce(@Color, [Colour] )
       AND [ListPrice] >= coalesce(@ListPriceMin, [ListPrice])
       AND [ListPrice] <= coalesce(@ListPriceMax, [ListPrice])
       AND ModifiedDate >= coalesce(@ModifiedDateMin, ModifiedDate)
       AND ModifiedDate <= coalesce(@ModifiedDateMax, ModifiedDate)