Update <long text> column in SQL Srvr databse

I need to update a long text column in a SQL server database. The text that has to be updated is a script and has a lot of single quotes( ') in them. Any help is appreciated...
Who is Participating?
In that case just do a find and replace to replace all instances of single quote (') with two single quotes ('') and then enclose the whole value within one pair of single quotes..
Is the script already stored in a variable or column or do you have to update it as a literal value?
RavishankaAuthor Commented:
It is not in a variable, we have to update it as a literal value.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.