If you are the poster earlier with same question, here was my answer:<BR><BR>Can use execute statement see vbscript doc. However as already suggested an array is better. BTW put a counter inside the do while loop not outside eg <BR>counter=0 <BR>do while not rs.eof <BR>myarr(counter) = rs("field") <BR>counter=counter+1 <BR>rs.movenext <BR>loop <BR><BR>also arr would haveto be properly dimensioned for it to work<BR><BR>could also do:<BR>dim counter, tempVar<BR>counter=0 <BR>do while not rs.eof <BR>tempVar=rs("field")<BR>execute("myvar" & counter & "=" & tempVar)<BR>counter=counter+1 <BR>rs.movenext <BR>loop <BR><BR>pretty slow though and if you don't know how many records came back then don't know how many vars used. Also if don't explicitlydeclare vars then have to turn off option explicit. Bad all around, use the array instead.