<< Thanks Bob and Buddy. I did both of those you recommended and it sped it up but still takes alot of time. It is a big(727,000 rows) temporary table. >>
If that field is indexed, or participates in a multi-column index, drop the index before you issue the update, then recreate it afterwards. -- Larry
