Is it possible to use a variable with an ‘IN’ statement in an SQL procedure ie.
@variable is a text string = ‘test1′,’test2’
SELECT column1_name FROM table_name WHERE column2_name IN @variable