dumb question

Sorry about this. But I've worked primarily in access for years.

Does SQL Server have a boolean or a yes/no data type for its table columns?

Thanks in advance,

Bill>Does SQL Server have a boolean or a yes/no data type for its table columns? <<

No, and you should not write SQL that way -- bit flags are too low
level for a high level language. We left BOOLEANs out for good
reasons having to do with 3VL, NULLs and consistent language model.|||Hi Bill,

No it doesn't, people usually use the BIT data type which holds 0 or 1; some
folk like myself use Y or N / T or F in a char(1) column.

Tony.

--
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]

"news" <wjfwjr@.hotmail.comwrote in message
news:eZOdnUO6lMk4AmDbnZ2dnUVZ_oCvnZ2d@.comcast.com. ..

Quote:

Originally Posted by

Sorry about this. But I've worked primarily in access for years.
>
Does SQL Server have a boolean or a yes/no data type for its table
columns?
>
Thanks in advance,
>
Bill
>
>
>