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...
RavishankaAsked:
Who is Participating?
 
reb73Commented:
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..
0
 
reb73Commented:
Is the script already stored in a variable or column or do you have to update it as a literal value?
0
 
RavishankaAuthor Commented:
It is not in a variable, we have to update it as a literal value.
0
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.