On Tue, Sep 04, 2001 at 10:27:12AM -0400, Behrens Matt - Grand Rapids wrote: | IMO, the whole "None" thing with SQL does violate the principle of least | surprise, though. I honestly can't see why... The SQL 'NULL' is "an unknown value" - as distinct from a 0 ´empty string'. To me, 'None' is an entirely obvious response - it represents the fact that we do not know the state of that value; in a quantum world, it's representing every state at once :) Still, if not the Principle of Least Surprise, it's certainly violating the Principle of Not Being a Tedius Pain :) It would be far more convenient for it to return '0' for a NULL in a Numeric-type column, '' when in a String-type column, and EOF for a Binary-type column. (If you see what I'm getting at) Perhaps something for the next rev of the DB API? :) -Z