Hey All,

For quite a while, we have been finding records that violate constraints on them, such ass NOT NULL fields containing
NULLS, fields with [CHECK (MyFiled = 'Y' or MyField = 'N')] with some other value in them. This is an old database, so
the tables that showed this behavior had been manipulated plenty of times over the years, something may have been
"unclean" about them. Anyway, we relatively recently just added a table to the database. One of the fields we call
BBLShare, which is defined [BBLSHARE Numeric(15,3) Default 0 NOT NULL], has just turned up a NULL value. This table
links to no other tables and only one application writes to it. The application explicitly sets BBLShare to 0, even
though it will default to that. What could POSSIBLY have caused this to happen?

Jason

--
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.