Parameterized Queries - Conversion problem for the IN clause

[NewTerminator]

I have an sql statment that looks like the one below:

declare @IDs varchar(100)
set @IDs = '''113''' + ',' + '''115'''

select *
from Student
where convert(varchar(30),cid) in (@IDs)

the cid column is of type int. print @IDs returns me '113','115', but i am still not able to retrieve records. Manually giving the numbers in the in clause returns records.

What is wrong in this statment.

Any help would be appreciated.

 

[JamesLean]

This FAQ describes how to do this:

Passing a list of values to a Stored Procedure
faq183-3979

--James