question SQL text field

[safo2000]

hi

u know when u have a field of type text.
well i am writting a STORED PROCEDURE using t-sql and trying to write on a text field (pmnotes) ie in the form pmnotes = pmnotes + newline + 'some other text', i dont want to overwrite the existing text but i want to APPEND to it after putting a NEWLINE. i tried it in the way i mentioned earlier but sql tells u can do this with text fields

can anyone help

thanks

 

[SQLSister]

Look in BOL at Writetext and UpdateText commands.

Questions about posting. See faq183-874