Selecting NULL date
From: D Huynh <remove.duchuynh_at_pacbell.net>
Date: Mon, 14 Jun 1999 13:56:46 -0700
Message-ID: <F%d93.229$7G6.60693_at_typhoon01.swbell.net>
What is the syntax for selecting date fields that are null. For example, table MyTable has columns Date1 and Date2, where Date1 ad Date2 are not completely populated. I want to be able to do SELECT * FROM myTable WHERE Mytable.Date1 > Date(1999,1,1) OR MyTable.Date1 = NULL
Date: Mon, 14 Jun 1999 13:56:46 -0700
Message-ID: <F%d93.229$7G6.60693_at_typhoon01.swbell.net>
What is the syntax for selecting date fields that are null. For example, table MyTable has columns Date1 and Date2, where Date1 ad Date2 are not completely populated. I want to be able to do SELECT * FROM myTable WHERE Mytable.Date1 > Date(1999,1,1) OR MyTable.Date1 = NULL
TIA. Received on Mon Jun 14 1999 - 22:56:46 CEST