Couldn't you just assign a DEFAULT value to the no null column?

MH