Re: Guideline to save 0 or NULL to a NUMBER column

Andrew wrote:

> Is that any guideline to either save 0(zero)or NULL to a NUMBER
> column? I personal prefer saving NULL to database to save space on a
> large table. Some people seem prefer saving 0. Is this just a personal
> choice or there is some guideline we better follow. Thanks.

Saving space should not be your criterion.

The sole criterion should be the way the column is utilized. If zero won't cause a problem use zero. If it will, use NULL.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)