I have a field set as varchar 8000, but I seem only to be able to enter about 1024? what's up w/that?
would you mind telling us HOW you think it only has 1024?<BR><BR>
well I copied out what I had into excel and used the Len() function
or maybe you meant, how I got there. I tried copying and pasting stuff deirectly into the table thru enterprise manager. it did not work so I typed it in and got stopped at 1024.
how big is your table? Do you have other large columns?<BR><BR><BR>when you give very large text data in your insert statement, what happens?<BR><BR>
it's the SQL thing....I had exactly same problem...what I did was I created simple ASP page, put textarea in it, paste your text in it, and insert it this way....this is the only way I could think of<BR>HTH.