，sql in

求助，sql in
select * from table where ziduan in (a,b,c,d)

如果 i="a,b,c,d"

要执行上面sql该如何写了

------解决方案--------------------
i="a,b,c,d"
i = "'" & replace(i, ",","','") & "'"
SQL = "select * from table where ziduan in (" & i & ")"