How do I set a column value to NULL in SQL Server Management Studio?

Question

How do I clear the value from a cell and make it NULL?

Answer 1

First the column should be null-able, you can right click, edit the table, select the column value you want to make null and press the CTRL + 0 buttons. After that click on any other column, if it is successfully updated, no message would be displayed, otherwise it would show you the error window.

Second method is to use update SQL query: update [TABLE_NAME] set [COLUMN_NAME] = NULL where [CRITERIA]