>select * from leavetable where startdate <= ?vp_end and enddate >= ?vp_start
But that way you will get the record which started on 01/15/2004 and ended on 06/15/2004. Is that what you want?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller The only thing normal about database guys is their tables.