>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 ?
--sb--