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

Question

Are there any updates in SQL Server 2008 to allow a variable for INpredicate clause WHERE?

Will this code work properly?

declare @InParams varchar(100) = '1,2';

select * from Category
where CategoryID in @InParams;

Answer 1

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

Answer 2

No - you still need to use either:

• split function, CLR function with tabular rating or table.
• dynamic SQL