Thanks for the reply. I had tried replacing the OR with an AND, and I still get the same results.

IF EXISTS(SELECT F00069, F00026, F01298, F01299, F01300

FROM patient INNER JOIN

tumor ON patient.UK = tumor.FK1 INNER JOIN

followup ON tumor.FK1 = followup.FK1 INNER JOIN

hospital ON tumor.UK = hospital.FK2

WHERE (hospital.F00026 = '0' OR hospital.F00026 = '1' OR hospital.F00026 = '2')

AND patient.F00069 = '1' AND followup.F01298 = ' ' AND followup.F01299 = ' ' AND followup.F01300 = ' ')

BEGIN

UPDATE followup SET followup.F01298 = 'C', followup.F01299 = 'C', followup.F01300 = 'C'

END

ELSE

PRINT 'Nothing to Update'

Thanks again...