读书人

sql in

发布时间: 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 & ")"

读书人网 >ASP

热点推荐