SearchRec

<% varName = "Ramesh Thiruchelvam" %>

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Set Rs = Server.CreateObject("ADODB.Recordset")

Conn.Open "DBQ=" & Server.Mappath("db.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"

SQL = "SELECT* FROM tbl WHERE fldName like '%" & varName & "%'"

rs.Open SQL, Conn
%>

<%= rs("fldAuto") %><br>
<%= rs("fldName") %><br>
<%= rs("fldEmail") %><br>