On Thu, 25 Mar 2010 14:15:01 -0700, Michael Conroy
wrote:

So my question is this, what
question should I be asking about the data to determine whether I store a
zero or null value in a numeric field?

I'd ask "Does a blank field have a different interpretation than a zero"? In
some cases it may not - a credit is a good example, where a zero default (and
nulls being forbidden) makes sense. In other situations they might indeed be
different - "How many birds are on my lawn" might be zero (I looked and there
weren't any) or it might be null (I haven't looked and don't have any idea how
many).

It's got to be decided on the basis of the real-life situation.
--

John W. Vinson [MVP]