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 & "% ' "