Setting a field to NULL works exactly like with any other value:

UPDATE Employees 
SET ManagerId = NULL
WHERE Id = 4