如何调用数组，做为子查询啊？

[NOZMC]

一个字段里面的值是这样的。'3203,3211,3212,3213,3215,3300,3301,3302,3303,3305,3306,3307,3309,3310 '
如何便利这个数组变成这样啊？
select * from test where id in ('3203,3211,3212,3213,3215,3300,3301,3302,3303,3305,3306,3307,3309,3310 )

[Tiger_Zhao]

DECLARE @table1 TABLE(a varchar(100))
INSERT INTO @table1 VALUES('3203,3211,3212,3213,3215,3300,3301,3302,3303,3305,3306,3307,3309,3310')     

DECLARE @sql varchar(max)
SET @sql = 'select * from test where id in ('''
SELECT @sql = @sql + a FROM @table1
SET @sql = @sql + ''')'
EXEC(@sql)

[NOZMC]

已经自己搞好了。