boolean type

[y3by]

hy ppl

i have a table in access and one of the field is a boolean, i want to creat a identical table in sqlserv7 and i want to define that field as boolean, but i don't find that data type ...
how can i define a boolean in sql serv7!!??!?

thanks

 

[tlbroadbent]

You can use the BIT data type. Some people prefer using TINYINT or INT for boolean columns because they are easier to work with in SQL Server. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[RickCole]

The equivalent in SQL Server is the data type 'bit' which can hold values of 0,1 or NUll.

Rick.