replace character in column with the unicode characters .. Only help with the syntax

I have two update scripts below, the first one works fine, but the second one is to replace an apostrophe with the unicode characters. I get an error on the second one, I assume the syntax is incorrect, can I get help with that ?

UPDATE dbo.CatalogDocuments
Set    Document = replace(Document, '"', '"')
WHERE Document IS NOT NULL AND Document <> ''


UPDATE dbo.CatalogDocuments
Set    Document = replace(Document, "'", '&apos;')
WHERE Document IS NOT NULL AND Document <> ''

Open in new window

AleksAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Shaun KlineConnect With a Mentor Lead Software EngineerCommented:
UPDATE dbo.CatalogDocuments
Set    Document = replace(Document, '''', '&apos;')
WHERE Document IS NOT NULL AND Document <> ''

Open in new window

0
 
AleksAuthor Commented:
Great thanks !
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.