I am using this code to convert a SQL recordset rsServiceList1 to an array for comparison. Set rsServiceList1 = Server.CreateObject("ADODB.Recordset") strSQL1 = "Select * from Services where catagoryid = " & "'" & mid(rsCatagoryList("ID"),2,36) & "'" & " order by name " rsServiceList1.Open strSQL1, ResourceCatalogDBConn rsServiceList1 could contain 4 or up to 20 rows. Example - ID,Name for each row. The first time it returns the correct amount of 4. The problem is that this repeats 12 times and it only returns 4 every time. DBServicesArray1 = rsServiceList1.GetRows Please Advise. thanks * * * This message, including any attachments, is intended solely for the use of the named recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution of this communication(s) is expressly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy any and all copies of the original message.