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

Since NULL is different from 0, I would use 0 since it is a NUMBER field - Why use NULL ( which means undefined or indeterminate and can introduce some issues with certain aggregate functions). The space savings are minimal at best and usage will be more 'standard' if NUMBER columns actually contain Numbers.. Just my 2c...

andyho99_at_yahoo.com (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.

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Mon Jun 16 2003 - 15:58:24 CDT