Could any body advise on the best way to update a text field on SQL server via the ADO command object and a stored proc. The amount of data exceeds 8000 chars so varchar can not be used. I have tried LongVarChar but still no good. I am trying to do this from VBscript within an asp page. The command object only has a limited number of variable types and text is not one of them!