Re: view puzzle

> Restricting to the date is pretty simple when it's there. It's
> just a select statement that has start_date <= working_date
> and end_date >= working_date. But how do I procede when there
> is no working date?

What's wrong with:
where working_date is null or working_date between start_date and end_date Or with this:
where nvl(working_date,start_date) between start_date and end_date

Of course, I assume start_date and end_date cannot be NULL...

HTH
Flado Received on Sun Jan 18 2004 - 08:26:28 CST