[dba-VB] Wha's up with True?

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



More information about the dba-VB mailing list