>> How do you create a column with the data type of boolean <<
You don't; BOOLEAN datatypes do not exist in SQL.
The reasons are complex, but the easiest to explain to a newbie is that
we have three valued logic (TRUE, FALSE, and UNKNOWN) and that all
datatypes in must commodate a NULL. Such columns would then be an
awkward four valued logic which is inconsistent. It does not work at a
Using the proprietary BIT datatype means that your code will not port.
Look at the different ways host languages use BIT values for Boolean --
nobody agrees at that low level.
Columns in a relational model are atributes; Booleans are states, not
attributes. Boolean columns are usually the result of a bad data model;
usually a file model where you are recording a state for later use, like
we did with punch cards.
Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, datatypes, etc. in your
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!