Re: How to include an IF() statement in SQL?

On Tue, 01 Sep 1998 17:30:40 -0700, Troy Perchotte <max_at_headroom.com> wrote:

>How do I include a condition within a select statement?
>Something like the following (only one that works):
>
>select if(customers.custid=customers.parentid,'',customers.name) as
>parent_name from customers;
>
>Troy Perchotte
>
>

You can use the DECODE function. E.g.:

SELECT DECODE(custid,parentid,NULL,name) parent_name FROM customers;

Bob Cunningham
bcunn_at_oanet.com Received on Wed Sep 02 1998 - 00:00:00 CDT