I would use an integer just out of ease. is it T F or Y N etc? 0 and 1 is pretty unmistakable and just as checkbox-friendly. As far is I know I think this just comes down to preference.
Jeff Watson [EMAIL PROTECTED] Tube Methods, Inc. 610-279-7700 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jan Johansen Sent: Friday, April 18, 2008 10:49 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Friday question G'Day, I need to add several columns to a table that will basically hold True/False information. In the past I have always handled this with a TEXT column defaulted to N and being able to change to Y. But I'm curious now if this kind of information is better handled with an INTEGER defaulted to 0 and using 1 as true. Opinions? Jan
