SET physician_Cert1_Name='Workers Compensation Medicine' WHERE physician_Cert1_Name='Workers' Compensation Medicine'
trying to update this table, but how do you handle apostraphes? seems like the easiest way is just to get rid of them. can anyone suggest how to get the above code to run and how you typically handle apostrophe's to avoid the coding error above. Thanks.