Set it to 1900 or something.... personally I hate NULL's in fields.... -----Original Message----- From: Fregas [mailto:[EMAIL PROTECTED] Sent: 07 March 2003 21:48 To: SQL Subject: Re: quick question
I don't know. A "DateUpdate" field might contain null, because it had never been updated.... ----- Original Message ----- From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Friday, March 07, 2003 3:21 AM Subject: RE: quick question > 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 Get the mailserver that powers this list at http://www.coolfusion.com
