SQL Server : UPDATE, SET with apostrophe in data

Question

The update statement below is throwing an error because of the ' within the ''

UPDATE Table 
SET [Company Name] = 'O'Donald Media Inc' 
WHERE [Company Name] = 'O'Donald Media  Inc'

Does anyone have a way to handle this?

Thanks

@vkp sorry for dupe! thanks for the reference – hansolo Sep 21 '16 at 19:15 — hansolo, Sep 21 '16 at 19:15

score 5 · Answer 1 · edited May 23 '17 at 12:08

5

When writing SQL by hand, use 'O''Donald Media Inc' for the string syntax. The '' sequence in a SQL string literal is a special encoding for a single apostrophe.

However, if done programmatically (ie. from code), use placeholders.

edited May 23 '17 at 12:08

Community

1
1

answered Sep 21 '16 at 19:10

user2864740

60,010
15
145
220

SQL Server : UPDATE, SET with apostrophe in data

1 Answers1