Wednesday, 14 February 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

casting - Why wasn't Tobey Maguire in The Amazing Spider-Man? - Movies & TV

In the Spider-Man franchise, Tobey Maguire is an outstanding performer as a Spider-Man and also reprised his role in the sequels Spider-Man...