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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
