• Hugo: so what you are saying is that REPLICATE uses varchar sizing i.e. 8000 and not the destination size unless you explicitly instruction the function to use something else as shown in your code. 😉

    Dumb function ! 😛

    --Shaun

    Hiding under a desk from SSIS Implemenation Work :crazy: