I have a table that contains a bunch of numbers like an excel spreadsheet. I need to replace certain numbers with certain other numbers.<BR><BR>Is there an easier way to do this than:<BR><BR>do while not rs.eof<BR>query2=update set field1=6 where field1=5<BR>conn.execute query<BR>query2=update set field2=6 where field2=5<BR>conn.execute query<BR>query2=update set field3=6 where field3=5<BR>conn.execute query<BR>...blah blah blah<BR>rs.movenext<BR>loop<BR><BR>The repetitive updates for each column seem very inefficient.<BR><BR>Any ideas?<BR><BR><BR>