Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Apostrophe in OpenQuery Update statement

How do I handle apostrophes in a update openquery statement? I've tried using the escape as well as doubling the apostrophe in People's with no success. What's the simple thing I'm missing? Example: Update OPENQUERY(SALESFORCE_BackUp,'Select Id, Country from Lead Where IsConverted = False and Country = ''China, People's Republic of''') set Country='China'
1 person has
this question
+1
Reply