I have a stored procedure that accepts one parameter to get records by status. However, I have one module where I need to pass two different statuses or values to the procedure at the same time like an "OR" operator. The problem is, I could do this in the procedure itself but then I have to add a "second" parameter to every list data source that uses the procedure. Then for modules that only pass one value, the other parameter will pass "null" which might also produce records.

In the parameter, I have tried "Value1, Value2" and "Value1|Value2" and "Value1;Value2". Am I going about it the wrong way?

Regards