Chintoo Semi Total Post:135 Points:947 Posted by Chintoo Semi April-17-2013 1:34 AM MSSQL Server MSSQL Server 1 Reply(s) 2371 View(s) Ratings: Rate this: Hi All! How do I parameterize a query containing an IN clause with a variable number of arguments, like this one? select * from Tags where Name in ('ruby','rails','scruffy','rubyonrails') order by Count desc In this query, the number of arguments could be anywhere from 1 to 5. I would prefer not to use a dedicated stored procedure for this (or XML), but if there is some fancy SQL Server 2008 specific way of doing it elegantly, I am open to that. Thanks in advance!