SQL Date/Time BETWEEN And Comparison Operators Work With Floats 

SELECT
	id
FROM
	[table]
WHERE
	[date] BETWEEN 
		ISNULL( date_started, 0 ) AND 
		ISNULL( date_ended, getDate() )

For Cut-and-Paste