Hi Armin

Way cool!

Thanks
Jim

>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