NP, basically it would simply ignore the NULLs as they are not valid dates (though a date field should never really contain nulls.)
-----Original Message----- From: Phillip B [mailto:[EMAIL PROTECTED] Sent: 06 March 2003 18:22 To: SQL Subject: Re: quick question Thanks for the verify! I'll also use the extra clause. Phillip B ----- Original Message ----- From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Thursday, March 06, 2003 10:41 AM Subject: RE: quick question > yes, it will not touch the NULL but you could always add another clause IS > NOT NULL > > -----Original Message----- > From: Phillip B [mailto:[EMAIL PROTECTED] > Sent: 06 March 2003 16:39 > To: SQL > Subject: quick question > > > I have a smalldate field in sql 2000 that can be null. If I want to delete > every record that has a date < now() it wont touch the NULL field? > > I'm pretty sure I'm right but want to make sure. > > Phillip B > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
