SQL Update Question

I have a pretty simple question on updating a date value within a table. I know the solution is a simple one but this is new to me so here goes.

I have to remove the date for 2 items within a table. Not sure if this is the proper way to do it.

UPDATE request_tbl
SET date = ' '
where line_id in ('0002146421','0003359594');


I'd appreciate any suggestions on this.

If this date column is not defined NOT NULL then you can do so, but this is a best practice to set the value of such a column as NULL instead of space or blank string.


UPDATE request_tbl
SET date = NULL -- set date equal to null
where line_id in ('0002146421','0003359594');


UPDATE request_tbl
SET date = ' ' -- your query is also correct, put the spaces
where line_id in ('0002146421','0003359594');


Remember spaces or null string is not equal to NULL.

Great. Thanks a bunch for your help.