sql fields required not null when they already are

had to change setting in the database so that other tools are able to clear a field where most of the field is null. 

If the field has no value why is does the database require the field to be not null.