Re: (OT) Complex SQL Statement

[pjotrik]

Really not the right place here, but OK. It would help to specify your db engine as well. It should go roughly like this:

select * from tbl 
where coalesce(actual_start, projected_start, some_deep_past) <= curre
+nt_date 
and coalesce(actual_finish, projected_finish, some_far_future) >= curr
+ent_date

[massa]

even clearer (IMHO) and shorter:

select * from tbl
where current_date between
coalesce(actual_start, projected_start, some_deep_past)
and
coalesce(actual_finish, projected_finish, some_far_future)

[Pancho]

Ahh, the beauty of an elegant and concise solution...

[boblawblah]

THANK YOU!