Parameters with multiple values in SQL / SSRS 2005

Hi ,

I am writing SSRS 2005 (SQL 2005) report.

In this report I have only one parameter @Param which is Query parameter i.e. writing in my SP at SQL level

SELECT...

FROM...

WHERE column_type = @Param

Now, this @Param is able to select multiple values in the SSRS report. I can handle this in SSRS by checkin the option "allow multiple values" and I can may be use JOIN function for this.

But the question is how do I accomodate this in my SQL i.e. is it something like below ??

WHERE column_type IN (@Param)

Please advise. Thanks