Hi,

I am new to using SQL Server. When I try to insert a string longer than 256 characters into a text field using the "Insert into" command (for e.g. "Insert into TempTbl(notes) Values ('a string longer than 256 characters') it gets cut off at 254th character. (A) Is there any other way to assign values to text fields? (B) How does UpdateText or WriteText command work? (C) Can I create a stored procedure with UpdateText command to which I will pass String values to be inserted into the text field? Please help.
Thank you.

Neetu Kumar