How can you campare two opposite conditions,means once you are cheking ing rd.rslt_dt= '01-JAN-01' then ri.actl_dt should come else rd.rslt_dt
& in where clause how can you write rd.rslt_dt <> '01-Jan-0001'.
If it will not equal to that date then how will decode work????