Parameterizing a SQL IN clause on an integer column?

Question

Jeff Atwood asked the original question about parameterizing a SQL IN clause, but I want to do this with an integer column. If I try the code from the original post I get the following exception, which makes sense:

Conversion failed when converting the varchar value '%|' to data type int.

Anyone try this before?

Answer 1

I think that Jørn Schou-Rode gave the best answer in the comments where he links to the top answer from this question:

Parameterizing a SQL IN clause?