wyrd Posted May 30, 2003 Posted May 30, 2003 I'm creating a table to keep track of items for a small business and wanted to create a boolean column called obsolete. If set to true, the item is obsolete and no longer sold, if set to false then it's a current item that can be purchased or back ordered. While looking through BOL, I noticed that there was no boolean data type. So my question is, what is the best way to handle true/false columns? Just use a bit column (0 = false, 1 = true)? Quote Gamer extraordinaire. Programmer wannabe.
Moderators Robby Posted May 30, 2003 Moderators Posted May 30, 2003 Bit is the way to go. Quote Visit...Bassic Software
wyrd Posted May 30, 2003 Author Posted May 30, 2003 Thanks. Quote Gamer extraordinaire. Programmer wannabe.
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.