>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 ISNULLAND chcschoolc ISNOTNULL
Now it will do! But be aware of the fact, that you won't catch any records where an empty string is stored.
Armin
Armin Neudert Regional Director (Stuttgart) of German FoxPro User Group dFPUG