Re: Can you use "If..Then" logic in SQL?

You can also use the decode function:

        select decode(column_a, condition, value if true, value if false)
        from    table_1;

Cheers
Adrian

Inna Minder wrote:

> This is not Exactly correct. You can use "Case Then Else" statment.
>
> SELECT 'Something' =
> CASE type
> WHEN 'One' THEN '20'
> WHEN 'Two' THEN '21'
> WHEN 'Three' THEN '22'
> WHEN 'Four' THEN '23'
> WHEN 'Five' THEN '24'
> ELSE '100'
> END,
> SomethingElse, SomethingElse2
> FROM table
> WHERE .....
> Thank's Anton Rakushkin
>
> David Russell <dbruce_at_kreative.net> wrote in message
> news:3741f9fb.19123628_at_news...
> >
> > SQL is not "procedural"... that's why PL/SQL was developed. You can
> > use some of the report writing features to get nested reports; but,
> > for true if/then/else logic go elsewhere: PL/SQL, 3GL, Java...
> >
> > David Russell
> >
Received on Mon Jun 07 1999 - 12:32:03 CDT