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

Re: dumb question

>> 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.

Re: dumb question

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" wrote in message
news:eZOdnUO6lMk4AmDbnZ2dnUVZ_oCvnZ2d@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
>
>
>