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

Question

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.

Accepted Answer

Something like this:UPDATE *TABLE-NAME-HERE*SET ATTRIB_VALUE=ATTRIB_VALUE_NUM_9WHERE ATTRIB_VALUE IS NULL OR ATTRIB_VALUE =''I&#8217;m not sure what your table name is based on your post, but I think that&#8217;ll get you what you need.

Advertisement

Answer