哪个大神可以帮忙把ASP的模糊搜索改成精确搜索啊

[固始找房网]

哪个大神可以帮忙把ASP的模糊搜索改成精确搜索啊

<%
if keywords<>"" then
 sql="select * from Info where 5=5"
 if cid<>"" then
	sql=sql & " and cid='" & cid & "' "
 end if
 if LX="sno" then '
	sql=sql & " and sno like '%"&keywords&"%' "
 end if
 if LX="sname" then '
	sql=sql & " and sname like '%"&keywords&"%' "
 end if
 sql=sql & " order by id desc"
 set rs=server.createobject("adodb.recordset") 
 rs.open sql,conn,1,1
 if not rs.eof Then
    proCount=rs.recordcount
    For i = 1 to proCount
    if rs.EOF then     
    Exit For 
    end if
%>