It doesn't matter what client side controls you're using, text box or otherwise. The stored procedure only cares about the specific field's datatype, as set in SQL Server. So if you have a varchar with a maximum lenth of 2000, then the stored procedure will want an input parameter like:<BR><BR>@yourtext VARCHAR(2000)
http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=171<BR><BR>The Bodytext input variable holds the length for an nText datatype. If you are using a nvarchar, just change the number of characters.