Jim Lawrence
accessd at shaw.ca
Sun Jan 1 14:53:29 CST 2006
Hi John: The bit data type; 1 and 0. Note; SQL is different from Access. Access uses -1 for true and 0 for false (yes/no) and SQL uses 1 for true and 0 for false. HTH Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John Colby Sent: January 1, 2006 8:22 AM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Yes/No in SQL Server What data type is used to store Boolean values in SQL Server? John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com