Thanks Michael,
I passed in @tests='45' to no avail.
Did you mean something else?

>This is a common question. That portion of the query is not parameterizable. You can get similar behavior by passing in the values in XML instead of a comma delimited list.
>
>-Mike
>
>>Threaders,
>>
>>Alter procedure dbo.pr_romtest_SelectTestStruc
>> @tests char(180)
>>as
>>set nocount on
>>select
>>[id],
>>[name],
>>[tests]
>>from romtest
>>where
>>[id] in (@tests)
>>
>>where id is integer and @tests is something like '4,5'
>>I want: if id=4 or id=5 then condition is true
>>I get: Sytax error converting the varchar value '4,5' to a column of data type int.
>>
>>Select * from romtest
>>Where
>>Id in (4,5)
>>
>>Works fine, but how can I alter my sp to work similarly?