>You cannot use group by or create index on bit data type.
Sergey,
I agree it is a PITA with respect to not being to group by. You then have to go through the hassle of converting to something you can group on and specifying that in the GROUP BY clause.
But when would you want to index on a bit field? That would be like indexing on DELETED(). < gd&r >
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao