create table crsctl (dptno   varchar(7),
                     crsno   varchar(7),
                     col3    varchar(7),
                     gened   varchar(7),
                     crsdesc varchar(31),
                     crscd   varchar(7),
                     col7    varchar(7),
                     col8    varchar(8),
                     col9    varchar(6),
                     col10   varchar(1));

create table crsscd (secno   varchar(7),
                     col2    varchar(7),
                     col3    varchar(8),
                     crdt    varchar(6),
                     crscd   varchar(7),
                     col6    varchar(6),
                     loc     varchar(7),
                     meetday varchar(7),
                     meethrs varchar(8),
                     maxenrl int);                     

select trim(dptno), trim(crsno), trim(secno), trim(crsdesc),
       trim(gened), trim(meetday), trim(meethrs)
  from crsctl, crsscd
  where crsctl.crscd = crsscd.crscd
    and maxenrl > 0
    and (0=1 or gened like '%B%' or gened like '%D%')
    and (meetday not like '%M%' or meetday = 'ARR'
                                or meethrs not like '%3%'
                                or meethrs = 'ARR')
    and (meetday not like '%W%' or meetday = 'ARR'
                                or meethrs not like '%3%'
                                or meethrs = 'ARR')
    and (meetday not like '%F%' or meetday = 'ARR'
                                or meethrs not like '%3%'
                                or meethrs = 'ARR');