Register Hereor login if you are already a member
What platform are you on?
Do you want to do it with SQL or a programming language?
If you are on the AS400, there is the %SCANRPL command in RPG.
Whatever version of SQL you have should include a %REPLACE.
Then use the Ascii or Hex definition for the single quote.