inputtext=request.form("inputtext") '取得输入的文本
set conn=server.createobject("adodb.connection")
connstr=...........
conn.open connstr
set rs=server.createobject("adodb.recordset")
sql="select fields1 from yourtbl"
conn.execute sql
fields1text=rs("fields1")
if InStr(inputtext,fields1text)>0 then
response.write "有"
else
response.write "没有"
end if