Thank you for the quick response. The example you provided works great. So I've tweaked it to update my test table which has about 2.5million rows. It's been running for 10 minutes and counting. The estimated execution plan looked ok and it was making use of available indexes. I'll post up the results when it completes.