Stuart: Oooh Sheldon, I'm afraid you couldn't be more wrong. Sheldon: More wrong? Wrong is an absolute state and not subject to gradation. Stuart: Of course it is. It's a little wrong to say a tomato is a vegetable; it's very wrong to say it's a suspension bridge. -- BBT
Kristian works in a shop with a bunch of superstar developers who always seem to find interesting ways to solve what most folks might otherwise consider to be trivial design issues. One particularly brightly shining piece of engineering involved a home-grown enum table in their database. Apparently, true, false and perhaps even FILE_NOT_FOUND weren't enough for these developers. No, they needed something that could handle gradations of right and wrong; true and false. They needed something that could handle situations where something was really true or really false. Something that was a bit more than boolean...
Name Id Text Boolean -1 True Boolean 0 False ExtraBoolean 0 MoreFalse ExtraBoolean 1 MoreTrue