Ankita Pandey Total Post:183 Points:1285 Posted by Ankita Pandey May-06-2013 1:56 AM MSSQL Server MSSQL Server 1 Reply(s) 1714 View(s) Ratings: Rate this: Hi Expert! How do I parametric 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. Please help me! Thanks in advance!