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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
