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!!!!