>>>>> "Josh" == Josh Berkus <josh@agliodbs.com> writes:
Josh> All DBAs are guilty of, to a lesser or greater degree, using
Josh> NULL to represent "None", even though NULL actually means
Josh> "unknown" according to the SQL spec. The rest of the SQL
Josh> spec is designed to support NULLs as "unknown", so this can
Josh> lead to problems in application. Like yours.
This is a good point, and since I know the range of values which can
go into those columns, it is easy to pick something to use as
representing "none."
roland
--
PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD RL Enterprises
roland@rlenter.com 76-15 113th Street, Apt 3B
roland@astrofoto.org Forest Hills, NY 11375