Terry,

Take a look at Re: Sending a list from vfp Message #829213.

>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?