ASP查询，帮忙
sql= "select   *   from   larchives   where   chatroom=yes   "  
sql= "select       user_id,name,sex,education,britherday,click,company,home,date,photo   from   larchives "

if   search_txt <> " "   then
sql1=sql   &   "   where   name   like   '% "   &   search_txt   &   "% ' "    
sql1=sql   &   "   or   sex   like   '% "   &   search_txt   &   "% ' "  
sql1=sql   &   "   or   education   like   '% "   &   search_txt   &   "% ' "
sql1=sql   &   "   or   britherday   like   '% "   &   search_txt   &   "% ' "
sql1=sql   &   "   or   click   like   '% "   &   search_txt   &   "% ' "
sql1=sql   &   "   or   cstr(company)   like   ' "   &   search_txt   &   " ' "
sql1=sql   &   "   or   date   like   '% "   &   search_txt   &   "% ' "
'sql=sql   &   "   or   chatroom   like   '% "   &   yes   &   "% ' "
end   if


我想把chatroom=yes   和查询结合起来，就是只查询表中chatroom=yes的内容，怎么写呀，高手帮忙，实在没分了，感谢感谢。

------解决方案--------------------
sql= "select * from larchives where chatroom=yes "
sql= "select user_id,name,sex,education,britherday,click,company,home,date,photo from larchives "