Removing apostrophe in result set
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 can be found in the manual, as is often the case.