Apostrophe Replacement

I know this is a very commonly asked question, but I can't find a solution
anywhere that I have looked.

I need to take the text that will be typed in paragraph form by the user
(textarea field) and do two things with it:

1. Store it in a SQL Server database field
2. Send it in an email upon page submit.

Of course, single quotes have caused problems, so I have this code:
strInternalDesc =
Replace(Trim(Request.Form("InternalDesc")),"'","''")

Problem is, it shows up like this in the email that is sent:
==============================
We''re in the process of
==============================

I would like to get rid of the double apostrophes, but not sure how. Went to
an article on ASPFAQ, and saw something which directed me to do this:

strInternalDesc =
Replace(Trim(Request.Form("InternalDesc")),"'",chr(34))

However, that just makes it a regular double-quote. I guess I could try and
find out what the character number for apostrophes are, but not sure where
that is. Besides, will that mess up my SQL Server or the email if I do that?