Index a bit field

Is there any way to index a bit field in a composite index?Yes, that is, if you are using SQL-Server 2000. Older versions do not
support indexing bit columns.
Gert-Jan
Mark DeWaard wrote:
> Is there any way to index a bit field in a composite index?|||I was able to successfully create an index on a bit field using query
analyzer.
What confused me was that bit fields don't show up in Enterprise manager's
drop down field for indexes. Also many websites still say that bit fields
cannot be indexed
Thank you for your response.
"Gert-Jan Strik" <sorry@.toomuchspamalready.nl> wrote in message
news:3F020E10.B19B4B4E@.toomuchspamalready.nl...
> Yes, that is, if you are using SQL-Server 2000. Older versions do not
> support indexing bit columns.
> Gert-Jan
>
> Mark DeWaard wrote:
> >
> > Is there any way to index a bit field in a composite index?