PMFJI. Yes, it's an integer data type but since the ODBC driver maps it to a logical field in VFP I prefer to use bit fields in this situation.
>Bit is integer data type not logical.
>
>>So that's what you meant by integer field?
>>
>>I'd take the bit over the integer for a flag field. For all intents and purposes it is a logical type. (just don't allow nulls)
>>
>>>From BOL:
>>>
>>>bit
>>>Integer data type 1, 0, or NULL.
>>>
>>>
>>>>I would say the bit type is a logical data type in SQL Server. Only possible values of 0 or 1.
>>>>
>>>>>The datetime fields cannot be empty in SQL Server. Usually NULLs are used instead in which case IS NULL operator cabn be used.
>>>>>There're no logical data type in SQL Server. You can use any integer field instead.
>>>>>
IF someDateField IS NULL
>>>>>...
>>>>>IF someLogicalField = 0
>>>>>
>>>>>
Daniel