hi,<BR> I have retrieved a field of text type from sql<BR>server database in to an ASP page and updated the<BR>text and submitted the asp page.<BR>1).I am using command object for calling the stored<BR>procedure.<BR><BR>It is giving follwing error.<BR><BR><BR>Microsoft OLE DB Provider for ODBC Drivers error<BR>&#039 80040e21&#039 <BR><BR>[Microsoft][ODBC SQL Server Driver]String data, right<BR>truncation <BR><BR>/brs/sips/DisplayDetailUpdate.asp, line 133 <BR><BR><BR><BR>If it is LESS than 255 characters NO PROBLEM it is<BR>accepting.<BR><BR>Can u help me to solve this problem.<BR>I am facing this problem since long back<BR><BR><BR>thankyou very much.<BR><BR>