Hi

Please can some one help me urgently with this
I have the following code
[code]
<%
Dim productColors, myString, myArray
myString = (prodRS.Fields.Item("prodColor").Value)
myArray = Split(myString,",")
Dim counter
for counter = 0 to UBound(myArray)
productColors = (myArray(counter))
Next
%>
[icode]
Which works as intended in splitting the string

What I now wish to achieve is a Recordset from another table
which will return records with the same values as returned by the split string function


eg:
"SELECT * FROM tbl_color WHERE colorCode = ????"
???? being each of the values returned by the split string function

If it makes a difference I am using an Access Database

Thanks in anticipation