<--- --------------------------------------------------------------------------------------- ---- Blog Entry: SQL Date/Time BETWEEN And Comparison Operators Work With Floats Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:192.view Date Posted: Aug 4, 2006 at 2:17 PM ---- --------------------------------------------------------------------------------------- ---> SELECT id FROM [table] WHERE [date] BETWEEN ISNULL( date_started, 0 ) AND ISNULL( date_ended, getDate() )