I need to blank out all cells in the color column

[Arnold]

What is the value for the UPDATE query if I need to "blank out" all the cells in a column that the Word BLACK was entered incorrectly?

[burrina]

What do you mean by Blank Out? Set value to Null? If you require BLACK to be entered correctly then why not add code to eliminate this?

[June7]

Maybe:

UPDATE tablename SET fieldname = Null WHERE fieldname="Black"

Use query builder to help build the SQL.