update issue with apostrophe

hconnor · #1 (**permalink**) 04-28-07, 14:02

UPDATE physician

SET physician_Cert1_Name='Workers Compensation Medicine' WHERE physician_Cert1_Name='Workers' Compensation Medicine'

Hi,

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.

mike

guelphdad · #2 (**permalink**) 04-28-07, 16:00

does this not work?

Code:

UPDATE physician

SET physician_Cert1_Name=
"Workers Compensation Medicine" 
WHERE 
physician_Cert1_Name="Workers' Compensation Medicine"

r937 · #3 (**permalink**) 04-28-07, 17:48

standard sql --

Code:

UPDATE physician
   SET physician_Cert1_Name = 'Workers Compensation Medicine' 
 WHERE physician_Cert1_Name = 'Workers'' Compensation Medicine'

but, i mean, why the update to remove them? apostrophes are good, if'n ya know how to use 'em

hconnor · #4 (**permalink**) 04-29-07, 11:08

as always, thanks.

Internet Services

Web Development

Digital Marketing

Consumer Tech