求助,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 & ")"
发布时间: 2012-05-21 18:04:41 作者: rapoo
求助,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 & ")"