Need help using WRITETEXT command

  • I have a column which is of type NTEXT. I will have to update the value of the column very regularly. When I use, UPDATE command, the text is truncated (not sure of the reasons). I find the WRITETEXT command updating the entire text to completion.

    For few of the records, I now observe that the column text contains single codes (') in it. But the WRITETEXT command does not allow me to insert the single codes (') into the text using the string congatenation method ('''+') as i do for the other VARCHAR columns using UPDATE.

    Ultimately, I need to be able to update the column values with large text having single codes ('). Please help/suggest.

    Urgently need help with this, as I need to put things to live site ASAP.

    Thanks,

    Sucharitha

  • We can escape single quotes by preceding it with an extra quote. see below

    http://sqlblogcasts.com/blogs/madhivanan/archive/2008/02/19/understanding-single-quotes.aspx

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply