What I do in those situations is to create a temp table (CREATE TABLE #tmpSomething) with one field, which will be the primary key, fill it using INSERT INTOs and join that table with MyTable. Just don't forget to DROP TABLE once you're done!

>The app allows the user to fill in a form with criteria and it then builds a SQL query. This is a simple query that looks something like:
>

SELECT * FROM MyTable
>WHERE MyVar IN (var1,var2,var3,....varN)