• Why not this

    select statement

    where FromDate >= '2010-10-02' and ToDate <= '2010-10-05'

    ?[/quote]

    yes, Thanks Phil. I am going like Horse eye. :w00t: