[hconnor]

I'm updating a table and I want to use the results of one field which has data (not null) to update another:

update physician
SET physician.physician_PostGrad='y'
WHERE physician.physician_MedSchool NOT NULL;

the code throws an error in the where clause. i've poked around for the correct syntax for using NOT NULL, but so far no results. suggestions please.

[gussery]

WHERE physician.physician_MedSchool IS NOT NULL;