Hey Jim,

here I am again :)

>Will this upadate the resschoolc field with the contents of the chcschoolc field if the resschoolc field is null and the chcschoolc field is not null?

UPDATE cisstudemo
  SET resschoolc = chcschoolc
  WHERE resschoolc IS NULL AND chcschoolc IS NOT NULL

Now it will do! But be aware of the fact, that you won't catch any records where an empty string is stored.

Armin