The report data is populated from a stored procedure. But in order to populate the drop down list, I set up another dataset from a query.

SELECT DISTINCT cipcode, ciptitle

FROM dbo.q_Outcomes

WHERE LEN(cipcode) = 2

ORDER BY cipcode;

Then set the @cip parameter "Available Values" to pull from this query. This works, but the LIKE part of the query in the original procedure goes away, and only one value is returned.

I hope this answered the question.