>One other suggestion. I don't know if this is feasible but you might try the sql statement without the PADR. Do your formatting of text after. I don't know if this will make a difference but it's worth a try.

Thanks for your help.
Yes I did remove the PadR() and the speed did improve (by 50%).
But it still to slow (about 5 minutes).