Yup, even in QA it returns nothing, but if I specify at least 1 valid items for each parameter it will return results, not what I'm looking for though.

Before the SELECT I have

If @parm1 = '' SET @parm1 = NULL

......

Then in my application I set the values to String.Empty if theres not a value before sending it to...

This optional parameter thing is driving me nuts, can someone please help. I have a report where the user can enter as many items in up to 8 search parameters,...