Hi Sergey

I had thought of that but unfortunately the remote database is a VFP and hence cannot use the CAST function. I should have made that clearer, sorry. Any other ideas?

Regards
Geoff Scott
>

ltDt = CAST(Null AS datetime)

>
>>
>>I have a little problem with a dynamic datetime field and .NULL. values.
>>
>>Is there a way to create a datetime field with a .NULL. value using a SELECT statement (i.e. remote table)?
>>I guess this is the same as as asking how do I create a datetime field with a .NULL. value in memory which is not possible but I live in hope.
>>