I would use T/F or Y/N because you invariably get a double negative question like?
"Does the employee have no lost time?" When answering this, an employee with 0 lost time is answered "1" and an employee with 1 or more lost time is answered "0". To me the ensuing chaos is not worth the space saved. My 2 cents worth for a Friday. Dave Fitts Risk Management -----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
