Look at the
String.Replace[
^] method. Just replace the apostrophe with a String.Empty.
You didn't say what you're were doing this for, but if you're looking at "securing" your SQL statements with that little trick, don't waste your time. Use parameterized queries instead.