Re: Ternary '?' in (PL/)SQL

<david_barts_at_my-deja.com> wrote in message news:8770q3$l5f$1_at_nnrp1.deja.com...
> Is there a way to simulate the '?' operator of C-like
> languages, e.g:
>
> select (char_column == 'Y' ? 'Yes' : 'No') from some_table
> where ... ;
>

try:

select DECODE(char_column, 'Y', 'Yes', 'No') from some_table where ... ;

Phil. Received on Tue Feb 01 2000 - 11:06:02 CST