You cannot use group by or create index on bit data type.

>Sergey,
>
>Why do you say the SQL Server bit data type is hard to use? One of the nice things about using the bit data type is that VFP automatically deals with the bit type as a VFP logical type in remote views. IMO, that makes it the logical choice (pun intended < g >) to use.
>
>~~Bonnie
>
>
>
>>>Hello,
>>>
>>> Can anyone please tell me the equivalent to a logical in SQL Server 7.0? Is there a logical field type in SQL Server 2000?
>>>
>>>Thanks
>>>
>>>Jim
>>
>>No, there is no logical type data in Sql Server. The best data type to use is Tinyint ( 1 byte, range 0-255) with values 1-true and 0-False. This way you can bind it directly to VFP checkbox. There is also Bit data type that stores 8 bit per byte but it's hard to use. Still it's usefull if you have a lot of logical fields per record.