In access/SQL how do I make only the null values in a column equal to value in another column?

I want to make only the blank cells in ATTRIB_VALUE equal to the values in ATTRIB_VALUE_NUM_9.

Answer

Something like this:

UPDATE *TABLE-NAME-HERE*

SET ATTRIB_VALUE=ATTRIB_VALUE_NUM_9

WHERE ATTRIB_VALUE IS NULL OR ATTRIB_VALUE =''

I’m not sure what your table name is based on your post, but I think that’ll get you what you need.