SQL Variables and ‘IN’ statements.

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