Re: Something like DECODE( ) in Oracle...
If you are using v7.3 or greater, try the following :
select acct,
case when crdr = 'D' then amount
else 0
end,
case when crdr = 'C' then amount
else 0
end
from <table>
where ...
HTH
Rudy
nextream wrote:
> Hi.
> Is there any function similar to decode() in Oracle?
>
> I am trying to get query result as follows:
> acct D C
> A01 100 0
> A02 0 200
>
> from the table as follows:
> acct crdr amount
> A01 D 100
> A02 C 200
>
> ...Thanks for any comments~