ASP问题希望都进来帮助解决一下谢谢!

<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from ok order by id asc"
rs.open sql,conn,1,1
Dim MyArray
MyArray = Array("a","b","c","d","e","f","g","h","i","j")
do while not rs.eof
for i = 0 to 9
这句主要要求判断出数据库yb这个字段里含有数组里列出那10个字母的数据，而数据格式如:数据库里有这几条数据ab,aa,qq,vv,aq,bxa,abc,amc
数据库yb字段一共这9条数据,我想列出所有包含数组里那10个字母的数据而且要包含2个的数据，就列出ab,aa这2条数据格式符合要求abc是包含3个了amc中间不符合要求必须包含数组里2个字母是ab,ac,ad都符合要求而不要中间无数组里字母的！希望ASP有经验高手帮下忙！在线跟回下帖子求助！还有就是如果要含有3个数组里面的数据全列出来怎么写,要求也是不要中间含有数组里没有的必须都是数组里面含有的谢谢了!
response.write rs("yb") & "<br>"
end if
rs.movenext
Next
Loop
rs.close
set rs=nothing
conn.close
set conn=nothing%>
请问下回答的朋友你的思路提醒了我非常满意！！就一点不清楚
in ("& inString &")

in这函数请您讲讲它的作用具体是什么函数？

说下思路,先列举出所有可能的数组组合,比如aa,ab,ac,ad,ae...等等,然后用这个组合做条件查询数据库.
代码如下:
<%
Dim MyArray
MyArray = Array("a","b","c","d","e","f","g","h","i","j")

dim i,j,ArrLength,inString
'获取数组长度
ArrLength=ubound(MyArray,1)
'构造查询条件
inString=""
for i=0 to ArrLength
for j=0 to ArrLength
if inString="" then
inString=MyArray(i) & MyArray(j)
else
inString=inString & "," & MyArray(i) & MyArray(j)
end if
next
next

inString=Replace(inString,",","','")
inString="'" & inString & "'"

'获取数据
set rs=server.CreateObject("adodb.recordset")
sql="select * from ok where yb in ("& inString &") order by id asc"
rs.open sql,conn,1,1