select in a view that returns constant value

[dmcmillan]

I'm trying to create a view that just selects from columns and also returns a constant value based on the data in a column. I can't get it though. Something like this:

create or replace force view lead_stats (
accession, value, insurance)
as
select a.accession, a.value, ('T' if b.code = 'C' OR 'F' if b.code <> 'C')
from tableone a, table2 b
where a.acct = b.acct


I can't figure out how to get the view to return a T if the b.code field has a C and to return an F if the b.code field contains anything but a C.
Any ideas are greatly appreciated.
Thanks.

[PAVB]

decode(b.code,'C','T','F')

[dmcmillan]

Thanks very much, that works perfectly!

[PAVB]

Glad to help.