I agree with Sergey. But one other way to do it is to make it a char with length 1. ('0' for False, '1' for True) Sometimes it's just easier dealing with characters than numerics.

Tom

>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