How to replace single quotes

How to solution replace " for ' it's simple you can use ASCII table chr(34)


To solve such problems, use the command like this

replace(,chr(34),”'“)