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?