How to filter a record in ADO recordset?

Answer 1

You can filter records in two ways
1) Use WHERE clause in your select query
2)This method is used for disconnected recordsets. You can use the filter property of a recordset.
e.g. rs.filter="name='xxx'"
You can master this syntax by looking up MSDN online and searching for filter property of ADODB

Answer 2

Tools>Filter

Answer 3

look here:

http://www.w3schools.com/ado/prop_rs_filter.asp
An example using sql query

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/db/northwind.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Companyname, Contactname FROM Customers WHERE CompanyName LIKE 'A%'"
rs.Open sql, conn
%>

Answer 4

Use the WHERE clause in your SELECT statement.
"SELECT * from table WHERE Name = 'Myron'"

You can chain up with OR or AND to get multiple WHERE selections. You can also use the HAVING clause in place of WHERE.