Parameterized Query Question

I am trying to use the following SQL query to return a set of values:

SELECT id, submit_date, company_name, request_type, status
FROM tblRequestForms
WHERE request_type IN (@.RequestType) AND status IN (@.Status)
ORDER BY id ASC

I have tried passing an array of string values to both @.RequestType and @.Status, but It does not work. Is there any way to pass multiple values like this using parameters?

Thanks,
AaronI wish it were that simple, but alas it's not.

This has been discussed on several threads. User Ghan has pretty much summed up the different ways you can accomplish this in this post:view post 308485

Terri