SELECT [Name],
           [Color],
           [ListPrice],
           [ModifiedDate]
FROM [Production].[Product]
WHERE ([Name] LIKE case when @Name is Null then [Name] else @Name end)
       AND ([Color] LIKE case when @Color is Null then [Color] else @Color end)
       AND ([ListPrice] >= case when IsNull(@ListPriceMin,0) = 0 then [ListPrice] else @ListPriceMin end)
       AND ([ListPrice] <= case when IsNull(@ListPriceMax,0) = 0 then [ListPrice] else @ListPriceMax end)
       AND (ModifiedDate >= case when @ModifiedDateMin is Null then ModifiedDate else @ModifiedDateMin end)
       AND (ModifiedDate <= case when @ModifiedDateMax is Null then ModifiedDate else @ModifiedDateMax end)

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

You can check my BLOG here