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

Hi John

It is 1 that is True.

/gustav

>>> jwcolby at colbyconsulting.com 27-03-2010 22:39 >>>
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