Hello Group,

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 = ' ' AND chcschoolc != NULL

Thanks
Jim