>Can anyone spead this up! This takes 10 minutes to run on looping through 2000 records several times.
>
The obvious answers are (1) unless your table has an index on the ALLTRIM() of the field, the UPDATE is never optimized, and (2) each pass makes 7 complete runs through the table unoptimized.