Hi Jeremy,<div><br></div><div>That where clause should work. If START_FIELD = 2010.01.31 and END_FIELD = 2010.03.14 and START_RANGE = 2010.02.22 and END_RANGE = 2010.02.26 then you'll find that</div><div><br></div><div>
WHERE (START_FIELD < END_RANGE) AND (END_FIELD > START_RANGE)</div><div>with the values</div><div>WHERE (2010.01.31 < 2010.02.26) AND (2010.03.12 > 2010.02.22)<br></div><div><br></div><div>Hope that helps.</div>
<div><br></div><div>Cheers,</div><div><br></div><div>Nick Barrett</div>