SELECT cmp_no, cmp_name, sci_obj, date_obs, date_end, observer, comments,
date_mod, time_mod FROM campaign WHERE (cmp_no between 1 and 3) and (cmp_name like '%st%' or cmp_name like '%ST%' or cmp_name like '%St%') and (((date_end is null) and (date_obs <= '1995/02/29')) or ((date_end <= '2000/12/31') and (date_obs >= '1990/01/01')));
