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

>VFP has many fine string functions that help get the job done. In my conversion to using MS SQL I have discovered the very easy-to-use sqlExec() function. However, not all VFP functions can be sent via sqlExec(). For the moment its the empty() function. So here is the question how do you code in sql the Empty() function of VFP:

>if  empty(someDateField)    ....
>if !empty(someDateField)    ....
>if ctod("01/01/2005")       ....
>if dtos(someDateField)      ....
>if  empty(someCharField)    ....
>
>if  empty(someLogicalField) .... Select someLogicalField = 0 ?
>if !empty(someLogicalField) .... Select someLogicalField = 1 ?

>is and empty field filled with nulls?
>

--sb--