searching I finally found an answer.
GilaMonster
You escape quotes by doubling them.
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'