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 [at] hotmail.com> wrote in message
news:eZOdnUO6lMk4AmDbnZ2dnUVZ_oCvnZ2d [at] comcast.com...
> 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
>
>
>