i m writing a program about facility booking but i have problem in my sql statement for searching the facility, booking date, start time and end time.<BR><BR>my sql statement:<BR><BR>sql = "SELECT * FROM tblbooking WHERE facility=&#039;"&facility&"&#039; and bookDate=&#039;" & bookDate & "&#039; and startTime=#"&startTime&"# and endTime=#"&endTime&"#" <BR><BR>if Not rs.eof then<BR><BR>response.write "Time is not available"<BR><BR>else<BR><BR>response.write "Time is available"<BR><BR>end if<BR><BR>My problem is this sql statement cannot handle the people who book the time between start time and end time. If the 1st people book the time from 10am to 12pm, so the 2nd people who want book from 11am to 12pm sure cannot make it, but my program still come out the response like "Time is available". So hope anyone can help me on this or suggest other way to search the time.<BR><BR>thank.<BR>