Can SQL Server 2008 use a variable in a WHERE IN clause

Question

Are there any updates in SQL 2008 to allow a variable for the IN of a where clause?

Declare @InParams varchar(100)
Set @InParams = '1,2'

Select * from Category
Where CategoryID in @InParams

Answer 1

No - still need to use either:

• a split function, Table Valued CLR or Table Valued function
• dynamic SQL

Answer 2

See here: Arrays and Lists in SQL Server (pick your version), or here http://www.sommarskog.se/dynamic_sql.html