I've got lots of varchar(500) in my table and the users want to store more information than 500 bytes. I basically need a text datatype. But when I try to convert the varchar to text it says it's going to truncate the data already in there. How do get around this? Also, what else should I look out for. I noticed I lose the ablity to run like the len function on a text datatype field when doing a select. Will I still be able to index and search on the field. etc.