New answers tagged replace
Use the REPLACE function, e.g. select replace(yourfield,'''','') from yourtable where ... Here we are replacing a single quote character with an empty string. Since SQL character literals are themselves enclosed in single quotes, we escape the single quote character in the literal by doubling it. More information about the use of the REPLACE function ...
Top 50 recent answers are included