hi,

when i use this WHERE clause,

UPDATE physician

SET physician_practiceArea_1 = 'heart attack'

WHERE physician_spec = ('Cardiology' OR 'Invasive Cardiology' or 'Noninvasive and Invasive Cardiology')

the entire column of physician_spec is updated (not just cardiology), without regard to the where clause. if i break it out and run each separately, it works fine.
for example,

.... WHERE physician_spec = cardiology

is there a way to make modiy that WHERE statement to make it work? Thanks.

Mike

yes change your = to the word IN and then leave your clause as is.

and change the ORs to commas, i.e.

WHERE physician_spec IN ('Cardiology' , 'Invasive Cardiology' , 'Noninvasive and Invasive Cardiology')

Just to clarify for you where your statement was going wrong:
WHERE physician_spec = ('Cardiology' OR 'Invasive Cardiology' OR 'Noninvasive and Invasive Cardiology')
i believe this gets intepreted as WHERE physician_spec = (TRUE).
What you ought to have had would have been :
WHERE (physician_spec = 'Cardiology') OR (physician_spec = 'Invasive Cardiology') OR (physician_spec = 'Noninvasive and Invasive Cardiology')

However, the "IN" answer that has been provided by Rudy is the best...

thanks a million. great forum.