works a treat, thanks for the help!! 

Most of my records have desp_day.  Yes I will only be updating the records that are NULL.   This will be run once only.  The source of the data are the...

I think the design of the database is fine, as there are records with desp_day in there, it's just these records have NULL as the desp_day because they were imported by...