Jessica

Hi,

I have a table consisting five columns Card No, Sdate, Edate, ATime, Etime

Now i want to get three columns info CardNo, Sdate, Edate from table. But i am facing problem when i get input from user to get their required info. For example user want to exact CRad name & his info from a specific Sdate to Edate.

Any effort will be appreciated .

Neobux

Following might help.. If SDate and EDate are date type columns..

SELECT CardNo, SDate, EDate FROM table WHERE SDate > INPUT_DATE AND EDate < INPUT_DATE

Alternately better method is..

SELECT CardNo, SDate, EDate FROM table WHERE INPUT_DATE BETWEEN SDate AND EDate