Wednesday, February 14, 2018

SQL Server : UPDATE, SET with apostrophe in data

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

-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

plot explanation - Why did Peaches' mom hang on the tree? - Movies & TV

In the middle of the movie Ice Age: Continental Drift Peaches' mom asked Peaches to go to sleep. Then, she hung on the tree. This parti...