Re: Problem with dates...

So, what kind of output do you see from:

select distinct revwmonth||' '||revwyear   from site_details s, activity a
  where revwyear is not null
  and s.cllocn=a.cllocn
  and a.outcome is null
  and revwmonth is not null
  and revwmonth!=' '
/

?

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l