I know that Chad, thank you. However, this is not our data. This is for a data conversion of another system to port their data into our system. Their field type is text in sql 2000. We have to pull their existing data out of their text field, append a line to it at the end (to denote where their system stopped and ours began), and insert it back into the text field. Then that data is later brought into our tables.
>Tracy,
>
>If it's SQL 2000, then you have a text field, but if it's SQL 2005, you should be using varchar(max) instead. Text is going away and varchar(max) is the replacement for MS SQL Server.
>
>HTH,
>Chad
>
>>Update: Just noticed you created your cursor as a varchar type. We need to append to the end of a text data type field in sql server 2000/2005.
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
