At work, when I am trying to access records from our SQL server, there is one field that is set up as VarChar and its a pretty long entry. We have it set up to 2200 characters. The thing is when I try to do a copy/paste from the field, I only get half of the field. When the data is accessed using ASP, it pulls out the entire entry. Is there a copy limit on SQL server from records? Is there a way to bypass this without having to access the data using asp/vb(maybe a table setting)? When I am trying to pull up this info its usually while I'm on the phone with a customer and it would be too much to have to access the information in that manner if I cant figure out how to get it directly from the SQL database. Anyone?