>Hi all
>I need to add text to a ntext field in an Update command from an ASP page to a SQL 7.0 table.
>
>I need the same command of this but to ASP for SQL:
>

>cSQL = "Update tablename Set ntextField = ntextField + " + Chr(34) + "New quoted text" + Chr(34)

>
>SQL Server don't accept CHR, then I tryed with CHAR, but OLEDB Provider error again.
>
>Please help me right now!!!! (my client is here with a gun to kill me)
>Thank a lot in Advance!!!!

Try

cSQL = "Update tablename Set ntextField = '"  + ntextField +  Chr(34) + "New quoted text" + Chr(34) + "'"