I have a table of rows and cols such as

Employee_Num Employee_Name
32587 Smith,John
65894 Jones,Tom
89652 Alias,Smith
32587 Smith,John

I need to wittle this list down to three unique employees. In VB I can do this easily with a collection using Employee_Num as a key. How can I do it with VBScript in ASP?

Am I correct to assume this table is in a database? Why not have the database handler the selection of only unique rows?

The table is in a database however there is additional data in the rows that is not unique which needs to be looked at. However I need to make another query for each employee and want it to be unique.

I'm not quite clear on what your response means, but it would seem to me that you just need to create the "unique employee" query and then the other query.

For your employee list, use this:

SELECT DISTINCT Employee_Num, Employee_Name FROM <employee table>

Peter
------------------------------------------------------
Work smarter, not harder.