The VFP OLE DB provider supports CAST() function.
>
>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?
>
>>>
ltDt = CAST(Null AS datetime)
--sb--