Let’s say we have a table Employees with a field Time and we want to update all Null fiels to 0
This the right statement to identify and update null values in a query.

Update Employees
set Time=0
where Time is null

Leave a Reply

Your email address will not be published. Required fields are marked *