>Can someone explain to me why Nulls should not be allowed in a database regardless of what type of field it is? TIA
It is recomended not to allow null for your PK :)
I am not a big fan of null values. If I allow null in a field that truly means that the value could be null (not known) (well and I also use null to represent an empty date).