日期:2014-05-17  浏览次数:20940 次

求助,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 & ")"