[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 89
  • Last Modified:

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

0
Aleks
Asked:
Aleks
1 Solution
 
Shaun KlineLead 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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now