Hi!

What you're using to connect to the SQl Server? The ODBC driver and OLE-DB provider allow passing HUGE data using parametrized queries. For example, in VFP you can write:

m.MyMemoField = "... Very Very long text ..."
=SQLEXEC(nConnectHandle,'INSERT INTO TEXTS (mText) values (?MyMemoField)')

In such case data are not truncated and can be quite large size for text field, far larger than the limitation for string length in the T-SQL language.

HTH.

>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