What to use for a Boolean data type with T-SQL

[gcole]

We need a true false field in a table. We used bit and int data types but the Query Analyzer isn't seeing the 0 and -1 values. We are using 7.0.

 

[RickCole]

The bit datatype on SQL Server can hold the values 1, 0, or NULL.

Are you saying you bit field does not contain any of these values??

Rick.

 

[gcole]

I need a field to hold -1 (Boolean true) or 0 (Boolean false). It also needs to be recognized by sql.

 

[fluteplr]

Smallint. This is due to the stupid VB standard of -1 being true instead of 1 being true.