Hi,

> > ((ScheduleStart < UserStart) and (ScheduleEnd > UserEnd)) OR
> (ScheduleStart BETWEEN UserStart and UserEnd) OR (ScheduleEnd BETWEEN
> UserStart and UserEnd)
>
> What about (ScheduleStart < UserEnd) and (ScheduleEnd > UserStart) ?

Indeed, but i use (ScheduleStart <= UserEnd) and (ScheduleEnd >= UserStart)
;-)

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://80.126.130.81