I have to compare the results of one recordset with a second recordset. If there is a match I need to flag the record that matches and swap that records hyperlink.<BR>RS A builds a table of hyperlinks. Each record in the table needs to be compared with RS B if a match is found the hyperlink will point to a different location. I have it working to a point, the only problem I have is that it only searches until it finds a match and stops looking further, so out of the 10 thousand records 1 thousand should match but only one match is found. How do I move through the entire recordset looking for matches?<BR>here is my test Code to flag matches so far= <BR><%<BR>If trim(objRS2.Fields.Item("sPartNo").Value)=trim(obj RSEco.Fields.Item("sDocNumber").Value) Then<BR>Response.Write "YES"<BR>Else Response.Write "NO"<BR>End If<BR>%><BR><BR>Seems so easy but I'm stumped.<BR>Thanks!