TSQL: Dates that lie between (intersect) from and to date?

Question

Can someone give me the tsql to find also the dates that lie inside the give from and to date.

select * from empc where
DateFrom >= p_todate AND DateTo <= p_todate

What I mean is that dates in between should also be captured (I do not want to use BETWEEN syntax)

please help

Answer 1

If you need to select all ranges that intersect the given range:

SELECT  *
FROM    empc
WHERE   DateFrom <= p_todate
        AND DateTo >= p_fromdate

Answer 2

Or you could use between:

SELECT  *
FROM    empc
WHERE   DateFrom BETWEEN p_fromdate AND p_todate

This gives you an inclusive range.