mrTexasFreedom I'm glad my code helped a bit, but mister magoo really identified the culprit, i think;
some process imported(and maybe still imports) data that should be nvarchar instead of varchar;
you should try to track down whatever that process is and fix it at the source; otherwise this cleanup-after-the-mess thing is going to be needed every time that other process runs.
Lowell