REPLICATE function is obviously broken then.
it only gives 8,000 repititions and thus must be geared to old SQL 2000 varchar max size of 8000.
Naughty MS have not updated the function to deal with the new data types.
--Shaun
Hiding under a desk from SSIS Implemenation Work :crazy: