Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2007

    Unanswered: update . . . WHERE NOT NULL . . .?

    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.

  2. #2
    Join Date
    Oct 2003
    WHERE physician.physician_MedSchool IS NOT NULL;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts