Thanks Mark,

I have managed to do something similar in my stored procedure using cursors etc.

The only problem I am having now is converting the varchar variable into the text field. I have tried using CAST and CONVERT but with no joy yet.

Steve