"Kevin Crosbie" <caoimhinocrosbai_at_yahoo.com> wrote in message
news:1113389220.0b2574c0299a35fed06aa75ccb45c754_at_teranews...
> You could try something like:
> SUM(case when e.xstatus IN ('A','P','X') then 1 else 0 end) as regist
> instead of COUNT(e.xlocator)
>
> and then remove the OR e.xstatus IN ('A','P','X') from the where clause.
This sure seems like exactly what I need. In my original post, however, I
failed to mention that I am still using dinosaur version. I can't find CASE
in the 8i docs and am guessing that it was added afterward. Is there
another way that I can accomplish the same thing with 8i?
Received on Wed Apr 13 2005 - 14:27:23 CDT
