Index on bit type column

Can we create an index in SQL Server 7.0 on Bit data type
column.

>--Original Message--
>Hi,
>Yes, You can create index on a bit data type column.
>Thanks
>Hari
>MCDBA
>"Lalit" <anonymous@.discussions.microsoft.com> wrote in
message
>news:4ada01c42c3f$8acb0820$a401280a@.phx.gbl...
>
>.
>
Hi Lalit,
As Tiber mentioned earlier. No, we cant create an index on bit data type
column in SQL 7 or earlier versions.
Only from sql 2000 we can create index on bit column.
Thanks
Hari
MCDBA
"Lalit" <anonymous@.discussions.microsoft.com> wrote in message
news:4d4e01c42c46$95e0b140$a101280a@.phx.gbl...[vbcol=seagreen]
> Can we create an index in SQL Server 7.0 on Bit data type
> column.
> message