How to automate escaping apostrophes in sql



  • 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.


Log in to reply