I have a text area on a form that once submitted is inserting into a sql 2000 database. If someone enters a large amount of text they will receive a truncation error. I am currently using the data type varchar with 4000 max characters. My question is: Is varchar the best data type to use when storing a large amount of text? Is 4000 characters the most you can store in one field?