How to automate escaping apostrophes in sql

[Carlos Daniel]

Hi,

I’m trying to develop a way to turn this:

insert into table (content) values (‘it’s a boy’)

into this:

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 ?

Thanks.