I'm just a beginner at ASP and I am trying to do a query in a database. I can display the whole database with this code:<BR><BR><%<BR>Set OBJdbConnection = Server.CreateObject("ADODB.Connection") <BR>OBJdbConnection.Open "DSN=Web400;UID=XXX;PWD=PASSWORD"<BR>OBjdbConnecti on.CommandTimeout=0<BR>SQLQuery = "SELECT * FROM QIWS.QCUSTCDT" <BR>Set RSCustomerList = OBJdbConnection.Execute(SQLQuery) <BR>%><BR><% Do While Not RScustomerList.EOF %><BR><BR><%= RSCustomerList("CUSNUM")%> etc...<BR><BR>but how could I run a query? For Example,I would like to run a query that would display the customer (CUSTNUM Field) 188888's information. <BR><BR>Matt1999@aol.com<BR><BR>Thanks!!!!