我用下面的模糊代码    怎么不能搜索到下面的  标题    比如我输入TOYES     搜索出的结果却是    sun flower series
set rss=server.createobject("adodb.recordset")
exec="select * from ejl where bt like '%"&request.Form("zhi")&"%'"
rss.open exec,conn,1,1


我的bt的内容是

   PEONY SERIES
   LOTUS SERIES
   SUN FLOWER SERIES
   BASKETBALL STAND SERIES
   TABLE TENNIS TABLE SERIES
   COMPETITION GAMES
   CHILDREN'S COMBINATION
   NAUGHTY CASTLE
   TRAMPOLINE
   TOYES
   LEISURE BENCH
   LEISURE LANDSCAPE
   RUBBER TILE
   TURF
   FRAMEWORK FENCE
   GROUND LIGHTING
   LITTER BIN
   ROAD FACILITIES

request.Form("zhi")输出的值是什么？有认真看过没有，

按理说，如果request.Form("zhi")的值是TOYES ，那么即使查不到数据也不可能会查找到sun flower series

我看输出的值拉  没错

输入toyes    查到的就是sun flower series

exec="select * from ejl where bt like '%"&request.Form("zhi")&"%'"
response.write exec
response.end
然后把输出的exec的字符串拿到数据库里去执行，顺道把你这个字符串帖出来！