要用SQL语句查的话恐怕不行
只能是用LIKE 查到类似的 在判断一下
如下:
set rs = server.createobjcet("adodb.recordset")
sql = "select * from people where love like '%11%'"
rs.open sql,conn,1,1
do while not rs.eof
mm = split(rs("love"),",")
for i = 0 to UBound(mm)
if mm(i)="11" then
response.write(rs("love")&"|")
exit for
end if
next
rs.movenext
loop
rs.close
set rs=nothing