How to automate escaping apostrophes in sql
I’m trying to develop a way to turn this:
insert into table (content) values (‘it’s a boy’)
insert into table (content) values (‘it’‘s a boy’)
Basically i’m dealing with fields in a query that the user fills with an apostrophe, which i then have to escape, by doubling that apostrophe. In a perfect world this would be dealt with in the frontend application, however this is not an option. I have to manually correct these queries, and as you can imagine, it’s very time consuming. Can you help me find some sort of macro that would fix these queries ?