>Sorry about that stupidity. Think I figured it out.
>
>

>select * from leavetable where startdate <= ?vp_end and enddate >= ?vp_start
>
>

>
>Does that appear correct for getting all dates?
>

Do you want only records that start and end between specified dates or you want records that start or end between specified dates ?