searching I finally found an answer.

GilaMonster

I find it strange when you double them it puts in the single quote. Thanks for the answer though!

Here is the corrected statement:

update [db.table] set [field]= '[BOB SAID:] "data" I want in table has multiple '' apostrophes '' in it.' where [tablefieldID] = '300'