jwcolby
jwcolby at colbyconsulting.com
Sat Mar 27 16:39:27 CDT 2010
I am working on my billing database which holds the data in SQL Server. I have a bit field and while it shows a value of -1, if I try to do a == -1 it filters out records. If I try == True it pukes. I have to do a <> 0 which returns records where that bit is set (true). So bit fields are not True / False? What "value" is it? And why does it display -1 but I can't test for that? TIA -- John W. Colby www.ColbyConsulting.com