Set variable with multiple int values and use IN with integer column

Asked Feb 25 '13 at 17:10

Active Dec 14 '15 at 08:37

Viewed 2,310 times

In SQL Server I'd like to do something to this effect...

DECLARE @Values varchar(1000)
SET @Values = '1, 2, 3'

SELECT blah  
FROM foo
WHERE IntegerColumn IN (@Values)

edited Dec 14 '15 at 08:37

Lukasz Szozda

asked Feb 25 '13 at 17:10

foluis

1

I think you're looking for something like this http://stackoverflow.com/questions/337704/parameterizing-an-sql-in-clause – Goose Feb 25 '13 at 17:16
Thanks Goose thas what I was loking for – foluis May 09 '13 at 22:23
Possible duplicate of [Parameterize an SQL IN clause](https://stackoverflow.com/questions/337704/parameterize-an-sql-in-clause) – Lukasz Szozda May 12 '19 at 17:17

0 Answers0