asp查询语句，很简单，但就是不会:(,该怎么解决

asp查询语句，很简单，但就是不会:(
sql= "select   *   from   larchives   where   chatroom=yes   and   education   like   '% "   &   search_txt   &   "% '   "


chatroom=yes   老是不起作用，怎么写这个查询啊，知道的帮忙，谢谢！

------解决方案--------------------
sql= "select * from larchives where chatroom= 'yes ' and education like '% " & search_txt & "% ' "