Michel,
Actually, null dates can exist in SQL Server. Empty dates are what do not exist in SQL Server. And, yes, those do get translated to a very early date value in standard import translations.
HTH,
Chad
>>I have date fields that have null values. I wish to return a data set of records of this type.
>>
>>
>>SELECT * FROM MyTable WHERE MyDate = NULL
>>
>>
>>This does not error out but it returns no values. Any suggestions?
>
>This does not exist in SQL Server. You will have to check for December 30, 1899.
_________________________________
There are 2 types of people in the world: