Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 To: Nilson Rishi
  Where is Nilson Rishi?
 Bangkok
 Thailand
 Nilson Rishi
 Tags
Subject: RE: test if a datetime field is empty on SQL
Thread ID: 248691 Message ID: 248719 # Views: 1 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, December 22, 2009 3:37:35 PM         
   


> Tushar,
> > You will have to check for NULL as the dates cannot be empty in SQL Server
>
> Thank you for this answer.Would you please tell me what data types could be empty in SQL Server?
>
> Regards,
> Nilson

AFAIK, empty is a concept for VFP and not really applicable to backend databases. There you have NULL or some value. VFP comes from xBase, which did not initially have NULL, so they had empty dates. You can have empty varchar strings or other variable length columns, but they are basically strings with 0 length.

Regards
Tushar

ENTIRE THREAD

test if a datetime field is empty on SQL Posted by Nilson Rishi @ 12/22/2009 10:46:02 AM
RE: test if a datetime field is empty on SQL Posted by tushar @ 12/22/2009 11:54:41 AM
RE: test if a datetime field is empty on SQL Posted by Nilson Rishi @ 12/22/2009 12:50:24 PM
RE: test if a datetime field is empty on SQL Posted by tushar @ 12/22/2009 3:37:35 PM