Re: Need Help With an Update Script

I could rather make sense of a business rule which says: The discharge_date will be entered once the actual discharge occurs. If the column contains NULL this indicates that the patient is still in. <<

Carry this thought one step further; add an "expected_discharge_date"
and "actual_discharge_date" to the table. Fill the
"expected_discharge_date" with a reasonable estimates based on other
data -- people with a hangnail should leave sooner than people who
lost limbs. You can do some planning and data mining with that
information.
.