How to update a column with a "blank" value

Question

How do I update a column value (varchar(20), not null) with a "blank" value?

Answer 1

If you want to update it with NULL you will need to change it to allow NULL. Otherwise update with an empty string "".