When you find yourself needing to update a record column only if the column is currently NULL (where you don't want to overwrite actual data),…