Dear Experts,

I just import a Vfp table having 'DATE' data field from Vfp to SQL server.
then i browse the VFP table i can see data and empty date field showing like ' / / : : AM'
fine its ok,

But, after importing this table in to sql server the date filed in the server table showing
'12:00:00 AM' for empty date fields and there is no problem for the date field having values.

Here i m facing problem is that i have report based on empty date filed, if the date filed is
empty i want print 'Unknown dates ' and if having value just print the date.

Here i can't check with Empty() Or Isdate() Or Len() function, Is there anyway other than this
to check the date field is empty or not ?. Or How i will i stop automatic storing values like this
while importing data from Vfp to Sql Server.

Secondly, Can anybody tell me SQL equalnt command of vfp's dDate = CTOD(' / / ')

Thanks in advance
Regards
Abdulla