yourAdoConnectionObject.Execute "UPDATE tblXYZ SET thentextfield=N'Hello
There' WHERE thePrimaryKeyField=1"
yourAdoConnectionObject.yourStoredProcedureOnTheSe rverThatTakesTwoParameters
"Hello There", 1
Open Books Online....Drill down
Accessing and Changing Relational Data
Advanced Query Concepts
Managing ntext, text, and image Data
for more information
"el_sherif" <el*******@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
how to update and retrieve ntext fields in my asp code
PLEASE HELP