Passing a string of multiple values to a Stored Proc to use in WHERE

[sdtucker]

I am trying to figure out how to pass a string such as
'1, 6, 9' to a Stored Proc to filter a recordset. I can't do a range, I need to be able to pass multiple, out of sequence values.

SIMPLY:
DECLARE @Var as varchar(10)
SET @Var = '1, 6, 9'

SELECT *
FROM

WHERE Table.Column in (@Var)

I have been banging my head! Please Help!!!

 

[sunila7]

hi,

have a look at this FAQ

faq183-3132

Hope it helps

Sunil